Select Statement

Hi,

Can you do an sql select statement that based on things that it should not contain e.g.

SELECT * FROM table WHERE country = 'United Kingdom' LIMIT 0 , 5

Basically i want the opposite to this statement which accepts anything but United Kingdom.

Sorry if i have not explained in properly.

Cheers,
Adam

 

SELECT * FROM table WHERE country <> 'United Kingdom' LIMIT 0 , 5

 

SELECT * FROM table WHERE country != 'United Kingdom' LIMIT 0 , 5

Works as well.

 

Thanks for that, say if i wanted this to work on both United Kingdom and also South Africa how would i go about that?

 

SELECT * FROM table WHERE country <> 'United Kingdom' AND country <> 'South Africa' LIMIT 0 , 5

 

Or

SELECT * FROM table_name WHERE country NOT IN('United Kingdom', 'South Africa') LIMIT 0 , 5

Code (sql):