I have this MySQL query.
I have database fields with this contents
sports,shopping,pool,pc,games shopping,pool,pc,games sports,pub,swimming, pool, pc, games
Why does this like query does not work?
I need the fields with either sports or pub or both?
SELECT * FROM table WHERE interests LIKE ('%sports%', '%pub%')