[RESOLVED] Noob MySQL Question

[trevorsg]

Hello,
I am trying to update a specific row in a MySQL table by identifying another unique column besides the primary auto incremented key.

The query I am trying is:

UPDATE users SET active=1 WHERE this=that

Where I have 'this=that' if I use id (the primary key) as "this" and some integer as "that", it works fine. Anything else I use returns a MySQL error.

What would be the best way to update a record for this specific criteria.

[bradgrafelman]

If the value is numeric, don't use quotes. If you're trying to compare the column to a string value, however, you need to surround the string in single quotes (like in PHP).

[trevorsg]

Ok. Works great. Can't believe it was something so simple. Thanks!