Need Help with this Query

[eluser]mah0001[/eluser]
You insert query is incorrect. Try something:

Code:

INSERT INTO users(email,password,username)  SELECT 'test1','test','test1' FROM DUAL WHERE NOT EXISTS (SELECT * FROM users WHERE username='test1');