Mysql查询 - 如何使用包含？

Question

In my table a column called group_members_id contains userid of 10 users. I've been trying to figure out how I can make a query with MySQL that fetch the details of that row if given userid matches any of those 10 userid.

"SELECT * FROM `table` WHERE `group_members_id`.contains('{$userid}')".

This code is not working. can anyone help me?

Answer 1

You can get use like this

"SELECT *
FROM `table`
WHERE `group_members_id` LIKE '%{$userid}%'"