I am stuck and getting errors with following string any ideas please im trying to prevent admin (user) being displayed in results.
SELECT * NOT LIKE 'admin' FROM users order by status ASC
I have tryed %admin% as well and i am stuck with errors!
3 Answers
Your syntax is wrong, you want to try something like this:
SELECT * FROM users WHERE username NOT LIKE '%admin%' ORDER BY status ASC
SELECT * FROM users WHERE user NOT LIKE 'admin' ORDER BY status ASC;
Put your where clause after the table name
3 Comments
gen_Eric
It's
WHERE username NOT LIKE 'admin'.
Jay Mee
I solved it like this SELECT * FROM users WHERE user_name NOT LIKE '%dmi%' order by status ASC
David B
@MultiMedia Andrew posted his answer first and they were pretty much identical, I recommend you accept his.
You don't need NOT LIKE if you're doing a comparison against a simple string. Also, as noted in others' answers your syntax order is mixed up:
SELECT * FROM users WHERE username != 'admin' ORDER BY status ASC
Cheers
WHERE.