Re: display multiple values, but only test for one

[Peter Brawley]

If you still need detailed help with this, here's what's needed. Create an empty instance of the target table, insert into it just enough rows to demonstrate the query problem, write the exact result you would expect from a correct query on those rows, mysqldump the test table and its rows into a script, then post here the script and the required query result.