The UPDATE syntax in the manual:

    SET col_name1=expr1, [col_name2=expr2, ...]
    [WHERE where_definition]
    [LIMIT #]

Yes, it is different than the INSERT syntax.
PS> ...but only there are like 150 different variables and it will take me
PS> forever to write a query like....

Therein lies your problem - quite likely you need to normalize!

- Julie

--> Julie Meloni

Find "Sams Teach Yourself MySQL in 24 Hours" at

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to