I have an entry in the table:
username = 2
text = a b c d e f
I would like to query the table and return a value if there is a match for the username with any of 'a b c d e or f'. I tried this >
SELECT * FROM `tablename` WHERE `username` = '2' AND `info` = 'a';
but it gives an error however, if I type >
SELECT * FROM `staff` WHERE `username` = '2' AND `info` = 'a b c d e f';
it will return a match, but I would ideally like a match if any of the letters are searched for in the query. I am just doing the queries in phpMyAdmin which is why the ` and ' are present. Any help would be great.