Take a look at REPLACE: http://www.mysql.com/doc/R/E/REPLACE.html
On Fri, 2002-07-26 at 10: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. > > For reasons too complex to go into at this stage using anything except SQL > is not possible. > > Any and all suggestions welcome. > > -Corey -- Diana Soares --------------------------------------------------------------------- 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
