Using LIMITS with Update statements

Tue Feb 17 21:55:51 CST 2009

I'd like to update only one record from a table with a specific WHERE search
statement, but the problem is that when I currently execute the code it
updates all of the matching records not just the top one, is there any way
around this?
Code that I tried to use but didn't work
Update Set T1= 'Test' Where col1='name' LIMIT 1
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090217/a84a7c6d/attachment.html