LMSouq
database Open

MySQL Like multiple values

WE
webmasters
1 month ago
3 views
Problem Description
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%')

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base