简单的SQL查询问题 [英] problem with simple sql query

问题描述

我有表supportFtacts其中sizeid的id由逗号分隔



现在我想获取大小id为1的所有记录吗？



以下是链接

：



http://sqlfiddle.com/#!2/30bd2/1 [ ^ ]



我搜索一个id时工作正常



现在我要选择所有列的大小为1或2



http://sqlfiddle.com/#!2/30bd2/2 [ ^ ]



我已经书面查询了

i have table supportContacts where sizeid has id's seprated by comma

now i want to fetch all records where size id has 1 in it ??

below is link
:

http://sqlfiddle.com/#!2/30bd2/1[^]

it works fine when i search for one id

now i want to select all column have size id 1 or 2

http://sqlfiddle.com/#!2/30bd2/2[^]

for that i have written query

select id, sizeid from supportContacts
WHERE FIND_IN_SET('1,2',sizeid)

哪个不起作用？任何帮助

which does not work ? any help

推荐答案

你应该使用下一个查询：

You should use the next query:

select id, sizeid from supportContacts
WHERE FIND_IN_SET('1',sizeid) OR FIND_IN_SET('2',sizeid)

这篇关于简单的SQL查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！