如何在Mysql PHP中匹配字符串中的值

Question

I have a table methodology in mysql where a column contain values like 1,2,3,4,5,6 or 3,4,6 or 25,4,7,8 in multiple row.

Now in my scenario i have a company which contain id 6 and i want to Match this value with methodology table value. But i don't have any idea how i can do it.

I am trying that first it get all values from methodology table one by one and after that match value of company.

can anyone please help me??

Answer 1

You can use FIND_IN_SET(your_id, columnname) function.

Query will be like

SELECT * FROM
methodology 
where FIND_IN_SET(your_id, columnname)

For more details about function please refer : http://www.w3resource.com/mysql/string-functions/mysql-find_in_set-function.php