SQL：使用IN子句搜索列值

Table name: `team`  
Column name: `team_members`  
Column value1: 1,72,34 //these are userids [Row1]  
Column value2: 72,38 [Row2]  
Column value2: 10,3  [Row3]

Now I want to match if login user's id exists in team_members or not.

现在我想匹配如果登录用户的id存在于team_members中。

For this, I fire a query as below :

为此,我触发如下查询:

<?php
$loginuserid = 72;
$query = 'SELECT * FROM `team` WHERE `team_members` IN ("'.$loginuserid.'")';
?>

Expected Result:

It must return 2 rows: 1 and 2

But it is not working like this. It returns only row1.

但它不是这样的。它只返回row1。

Kindly, suggest the solution.

请建议解决方案。

1 个解决方案

#1

I found the solution by using FIND_IN_SET() as recommended. Thank you! Following is the query which resolved my issue:

我按建议使用FIND_IN_SET()找到了解决方案。谢谢!以下是解决我的问题的查询:

SELECT * FROM `team` WHERE FIND_IN_SET('72',`team_members`)

Result: This returns : row1 and row2

结果:返回:row1和row2

1 个解决方案

#1

更多相关文章

随机推荐