Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k & phranque

Message Too Old, No Replies

Select statement..with a twist

Can this be done?

10:23 am on Mar 22, 2003 (gmt 0)

Full Member

10+ Year Member

joined:Nov 17, 2002
votes: 0

Hi There,

I need to run a SELECT command on a table in my database, but instead of it being

SELECT * FROM table_name WHERE 1 AND status = 4

I need it to do the opposite, and select, when the status isn't 4?

I tried

SELECT * FROM table_name WHERE 1 AND status!= 4

but it didnt work. (there was a space before the "!", WW removed it)

Does anyone know the parameter for this?


10:25 am on Mar 22, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 28, 2002
votes: 0

How about:

AND status <> 4

10:28 am on Mar 22, 2003 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
votes: 0

Yes, you can use 'not equal' or 'not in' in most versions of SQL.

<filedname> <> 4
<filedname> not in (4)


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members