Welcome to WebmasterWorld Guest from 54.162.213.67

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
posts:313
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?

Regards,
William.

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

Junior Member

10+ Year Member

joined:Jan 28, 2002
posts:166
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
posts:2162
votes: 0


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

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