exclude results of a query

[robsgaming]

I run the query:

select * from user order by pts

one of the users name is rob
another is dark pulse

how do i exclude these 2 names from the results of the query?

[pahikua]

SELECT * FROM user WHERE user_name NOT LIKE "rob" OR NOT LIKE "dark pulse" ORDER BY pts

where user_name is whatever you named the field that designates the users name

[Weedpacket]

Originally posted by pahikua
SELECT * FROM user WHERE user_name NOT LIKE "rob" OR NOT LIKE "dark pulse" ORDER BY pts

where user_name is whatever you named the field that designates the users name

Using LIKE is a bit redundant; you're wanting to make exact matches, I presume.

SELECT * FROM user WHERE user_name!="rob" OR username!="dark pulse" ORDER BY pts

Or

SELECT * FROM user WHERE user_name NOT IN ("rob", "dark pulse") ORDER BY pts

Basic SQL, really.

[robsgaming]

thanks for the help... always get the help when i need it here 🙂