[Resolved] Select from where IS NOT?

[Sayian]

Is their a way a can use somthing that WILL NOT return result's from mysql .. for example ..

if i wanted to display rating's of articles that where the highest , but NOT rated a perfect 10..

Is their a SQL IS Not statement?

[leatherback]

Hm..

Have you tried <> or NE ?

J.

[Sayian]

Im not familiar with <>

Ill look into it , is that the only way?

[robert_w_ark]

SELECT [something] FROM [table] WHERE NOT LIKE '10'

That might work 🙂

[Sayian]

I tried to add that to this query , and SQL shot me an error

$s = "select id from $tb_users where user_type = 1 and image_status = 'approved' and total_ratings > 2 WHERE rating NOT LIKE '10' ORDER BY average_rating DESC LIMIT 0,1";

where should i add the NOT LIKE '10' ?

[Weedpacket]

Originally posted by Sayian
Im not familiar with <>

It's the same thing as PHP's != operator. Think of it as reading "less than or greater than".