Testing for existence of a record before insert

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');

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004