Empty a specific field in a table from DB?

[MrE03]

I'm not really too savvy in the db, but I wanted to empty the information in a specific field inside the table

for example:

orders>customer name

inside the orders table I want to empty ONLY the customer's name

[mfleeson]

Hi,
Assuming you have access to run sql, i.e. phpmyadmin or commandline mysql or you can write a php function you just need to call a mysql update.

i.e. run the sql
UPDATE orders set customers_name="";

which will wipe all customers names, or for a specific order id:

UPDATE orders set customers_name="" where orders_id=XYZ;

changing XYZ to your relavent order id.

Best Wishes

Mark