subject:"If\(\) syntax question"

RE: If() syntax question

2004-04-21 Thread Mike Johnson

From: Don Dachner [mailto:[EMAIL PROTECTED] > Is it possible to do something like this? > > If(select * from xxx, "if record found"..update it, "if > record not found" ..insert it) Try the REPLACE INTO syntax: http://dev.mysql.com/doc/mysql/en/REPLACE.html -- Mike Johnson Web Developer Sma

If() syntax question

2004-04-21 Thread Don Dachner

Is it possible to do something like this? If(select * from xxx, "if record found"..update it, "if record not found" ..insert it) Thanks, Don