本文介绍了MySQL喜欢多个值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有这个MySQL查询.
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%')
推荐答案
(a,b,c)列表仅适用于in.对于like，您必须使用or:
The (a,b,c) list only works with in. For like, you have to use or:
WHERE interests LIKE '%sports%' OR interests LIKE '%pub%'
这篇关于MySQL喜欢多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！