mysql turning csv into OR :P - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: mysql turning csv into OR :P (/showthread.php?tid=76016)
mysql turning csv into OR :P by -dt- on 07-11-2007 at 04:35 AM
Ok well, Im using a sub query which returns some numbers separated by commas and i want mysql to treat those like an OR statement, at the moment everything seems to work except it only returns one result 
instead of many rows
The query
code:
SELECT logMessage FROM `scripts_info` WHERE revision = (SELECT revisions FROM `scripts_log` WHERE path="/test")
The sub query will return "5,6"
and in the table log message there are two rows, the first row revision column is set to 5 and the other to 6
the current query only returns the first one with the revision 5 when it should really return both rows
help?
RE: mysql turning csv into OR :P by Matti on 07-11-2007 at 06:35 AM
I can't test this at my PC because I don't have a local host nor MySQL installed (yet) and I'm losing my MySQL knowledge as I'm not able to make use of it, but maybe the reference might help? After a quick look, it seems like the IN statement might do this?