Forum Moderators: open

Message Too Old, No Replies

Mysql Query

         

artie2004

4:16 pm on Aug 23, 2006 (gmt 0)

10+ Year Member



hi. i have the following table:

CREATE TABLE users (
userid,
username,
password,
email,
name,
address,
country,
PRIMARY KEY (userid)
)

how do i query all users not in the country of jamaica? Thanks.

coopster

4:19 pm on Aug 23, 2006 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



SELECT * FROM users WHERE country <> 'jamaica';

artie2004

4:27 pm on Aug 23, 2006 (gmt 0)

10+ Year Member



thanks coopster.