[ADMIN] Testing for existence of a record before insert

[Rob Anderson]

I am trying to find a way of performing something similar to the SQL-Server SQL of

 

IF NOT EXISTS (SELECT id FROM a_table WHERE id='akey')

THEN INSERT INTO a_table (id, name) values ('akey', 'adetails');