Bug #24075 No manual entry for WHERE [field] IN ([coma separated values])
Submitted: 8 Nov 2006 8:29 Modified: 8 Nov 2006 13:06
Reporter: Andris Priedīte Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:All ? OS:
Assigned to: CPU Architecture:Any

[8 Nov 2006 8:29] Andris Priedīte 
Description:
Hello,

I think MySQL has no entry about WHERE [field] IN ([coma separated values]) statement. At least I can't find it anywhere. And if it is somewhere then the bug would be that it is very hard to find.

Thank you.

PS. I hope I don't duplicate this bug report.

How to repeat:
Try search for it.

Suggested fix:
-
[8 Nov 2006 11:29] Valeriy Kravchuk 
Desn't this page,

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html

explain all you need to know about IN? Please, check.
[8 Nov 2006 11:44] Andris Priedīte 
Yes, it explains, but it's little bit hard to find this description if I don't know that it must be in Comparison Functions and Operators.

Anyway, sorry for false alarm.
[8 Nov 2006 13:06] Valeriy Kravchuk 
There is a link from 

http://dev.mysql.com/doc/refman/5.0/en/select.html

to

http://dev.mysql.com/doc/refman/5.0/en/functions.html

and, from there, to

http://dev.mysql.com/doc/refman/5.0/en/non-typed-operators.html

So, it is not very hard.