[SOLVED] Help with query

[Gmunky]

I want to write a query to retrieve information about users that are not in the list of userids.the list will be around 50 ids;

 

is there a much simpler way than this: select * from user where userid != 23 AND userid != 24 AND userid != 46 AND so on....

[GingerRobot]

Sure, use the NOT IN operator:

 

SELECT * FROM `user` WHERE `userid` NOT IN (23,24,46)

[teng84]

Sure, use the NOT IN operator:

 

SELECT * FROM `user` WHERE `userid` NOT IN (23,24,46)

 

i guess there no not in operator it is the list operator when you use the IN and not i think is part of the logical operator which are and or not

[clearstatcache]

i guess there no not in operator it is the list operator when you use the IN and not i think is part of the logical operator which are and or not

 

-->> yes u may use ds....

SELECT * FROM `user` WHERE `userid` NOT IN (23,24,46)

 

 

[teng84]

i guess there no not in operator it is the list operator when you use the IN and not i think is part of the logical operator which are and or not

 

-->> yes u may use ds....

SELECT * FROM `user` WHERE `userid` NOT IN (23,24,46)

 

 

 

who post this you just repeat my words and this is given above

SELECT * FROM `user` WHERE `userid` NOT IN (23,24,46)

 

are you HMMMMMMMMM ?????????

[clearstatcache]

no..wat i mean is gingerrobot's code may be used......

heheheheh....