Hi this might be an easy question. but after trying multiple things i gave up.
Cant see what is wrong with this query:
IF NOT EXISTS(SELECT email FROM gebr_tickets WHERE email ='test@test.nl' )
INSERT INTO gebr_tickets (name,gebr_name, password, email, RelatieID)
VALUES ('k','k','cmmNkftA','test@test.nl',170)
the error is :
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS(SELECT email FROM gebr_tickets WHERE email ='test@test.nl' ) INSERT INTO'