On Fri, 2002-07-26 at 05:17, Corey Wallis wrote: > Peoples, > > I'm currently trying to work out if this is possible by SQL. I have the need > to use SQL and only SQL to achieve the following. > > If a record exists and meets a certain criteria (i.e. field X = '1234') then > update the record. If the record doesn't exist then insert it.
See if REPLACE does what you want: http://www.mysql.com/doc/R/E/REPLACE.html --Dan Koch --------------------------------------------------------------------- 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