Hello All, I'm looking for a date function that will allow me to update only the year portion of a field to a particular year, in this case, 2002.
I've tried "UPDATE [table] SET YEAR([field]) = '2002' WHERE [field] > 2002" but this gives me an error. The MySQL documentation only seems to cover using SELECT with the YEAR function. What is the correct syntax for doing this? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
