FAQTs - Knowledge Base - View Entry - Is it possible to update the same field used in the WHERE clause of an UPDATE statement?

faqts : Computers : Databases : MySQL : Language and Syntax : Queries : Update

+ Search

Add Entry Alert

Manage Folder

Edit Entry

Add page to http://del.icio.us/

Entry

Is it possible to update the same field used in the WHERE clause of an UPDATE statement?

Dec 17th, 2004 05:48
Michael Sodos, Mark Richards,

Yes, at least in Sybase. 

update t_fares
set entry_date = "Jun  1 2000"
where entry_date = "Jun 28 2000"