MySql: Update where and

[SJames]

Is there a way to say the equivelent of:

 

UPDATE table SET field='value' WHERE field='value' AND field2='value'

 

What I'm asking is if there's a way to say AND, near the end.

[hostfreak]

I don't fully understand your question. Are you asking if it is possible to do something like you posted? If so, yes. AND is a mysql operator http://dev.mysql.com/doc/refman/4.1/en/non-typed-operators.html . Therefore, your code should work fine as it is now.