MySQL 喜欢多个值

Question

我有这个 MySQL 查询。

我有包含这些内容的数据库字段

sports,shopping,pool,pc,games 
shopping,pool,pc,games 
sports,pub,swimming, pool, pc, games   

为什么这样的查询不起作用？我需要运动或酒吧或两者兼有的领域？

SELECT * FROM table WHERE interests LIKE ('%sports%', '%pub%')

Answer 1

更快的方法:

WHERE interests LIKE '%sports%' OR interests LIKE '%pub%'

这是:

WHERE interests REGEXP 'sports|pub'

在此处找到此解决方案:http://forums.mysql.com/read.php?10,392332,392950#msg-392950

更多关于 REGEXP 的信息:http://www.tutorialspoint.com/mysql/mysql-regexps.htm