Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

where ... or....

Feb 23, 2003, 10:54 AM
courierb
User (344 posts)
courierb's avatar
Feb 23, 2003, 10:54 AM
Post #1 of 4
Views: 4539
Shortcut
Quote Reply
where ... or....
i wonder what is the correct query?

select * from table where columnx=id1,id2,id3

select * from table where columnx=id1 or columnx=id2 columnx=id3

many thanks in advance
Feb 23, 2003, 11:06 AM
Paul
Veteran (19537 posts)
Feb 23, 2003, 11:06 AM
Post #2 of 4
Views: 4338
Shortcut
Quote Reply
Re: [courierb] where ... or.... In reply to
Try them both :)
Feb 23, 2003, 5:28 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Feb 23, 2003, 5:28 PM
Post #3 of 4
Views: 4364
Shortcut
Quote Reply
Re: [courierb] where ... or.... In reply to
Or the better thing to do is use the IN function....

select *
from table
where (columnx IN (id1,id2,id3))
========================================
Buh Bye!

Cheers,
Me
Feb 24, 2003, 1:08 PM
courierb
User (344 posts)
courierb's avatar
Feb 24, 2003, 1:08 PM
Post #4 of 4
Views: 4338
Shortcut
Quote Reply
Re: [Stealth] where ... or.... In reply to
Thanks
the last one works for me. Thanks you