field data

[tyrannus]

I need to find out how to clear data of a field and set it to 0. I have a table with a field named products_ordered. I want to delete the data in that field only while keeping all the rest of the data. So, far I cannot find any info on how to do this.

 

[feherke]

Hi

[b]update[/b] tyrannus_table [b]set[/b] products_ordered=0;

Feherke.

http://rootshell.be/~feherke/

 

[tyrannus]

Wow thats easy!! Thanks. I am still new to mysql and I found the update syntax on the site but was still unclear with it. I appreciate it.