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?