mysql FIND_IN_SET returned an empty result set

62 views Asked by At

I have the following input table "eastate_facilitylist":

eastate_id facilityList
1 2,3,4
2 1,3,4
3 1

I want to select the "eastate_id" values that have a value inside it, so I've crafted the following query:

SELECT eastate_id FROM `eastate_facilitylist` 
WHERE ( FIND_IN_SET(3, facilityList))

Problem is that it returns an empty result set.

I'm using MySQL 5.7.31.

How can I fix my query?

0

There are 0 answers