MYSQL Functions

[eluser]jedd[/eluser]
[quote author="vtafsar" date="1259578380"]
but it is not updating the field like what I am looking for.
[/quote]

Do you know if it's not updating because the query is wrong, or because the data doesn't match?

You can confirm whether the query is okay by checking what AR turns your query into - the actual string that it sends to the database. The process for doing this is described in [url="/wiki/FAQ"]the FAQ[/url] - the first question in fact.