SQL -- IF EXISTS doesnt work

Question

Im trying to doing a sql query that is not working, I would like to add one element to a table only and only if that value is not in the table, something like that:

IF EXISTS (Select `id` from `artists` Where `artist`='"$artist"') Do Nothing
ELSE      Insert into `artists` (`artist`) values('".$artist."')

What is the best way to do that?

PS: I have tried to look for that information by google and in the forum, but I dont understand the idea

Thank you very much in advance

PS2: Sorry, Its a MYSQL database

Maybe a duplicated entry: [see here](http://stackoverflow.com/questions/1361340/how-to-insert-if-not-exists-in-mysql) — Vincenzo Petrucci, Sep 25 '13 at 15:28

score 2 · Answer 1 · answered Sep 25 '13 at 15:22

2

What about using IF NOT EXISTS...

Something like:

IF NOT EXISTS (Select `id` from `artists` Where `artist`='"$artist"') Insert into `artists` (`artist`) values('".$artist."')

answered Sep 25 '13 at 15:22

Derek

6,565
3
28
47

SQL -- IF EXISTS doesnt work

1 Answers1