Shoutbox

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?

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?