Check if record exists mysql conditional help

[gte806e]

I was wondering if it is possible to do this logic in a single mysql statement.

Check if a record exists

if FALSE
insert record into database
else
update record

I'd like to do this with a single sql query. I know there is a function to check the existance of a table, but i'm trying to check the existance of the record.

Could you possibly write a conditional in mysql? If so any insight would help.

Thanks

Jesse

[gte806e]

Found a solution!

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]

http://www.phpbuilder.com/board/newreply.php?s=&action=newreply&threadid=10296478

Just in case somebody else needs to do this

Jesse