laravel查询逗号分隔字符串的位置

Question

Using Laravel to check if a value is in an array stored as comma delimited string, example string stored in mysql table 1,14,15,20,25

So I'm trying to add comma's at the start and end to search appropriately

$query = Profile::whereRaw("',' + cf_profile.sub_category_id + ',' LIKE '%,$sub_category->sub_category_id,%'");

Can anyone let me know where I'm going wrong here, as it's returning no results.

Answer 1

You can use FIND_IN_SET():

WHERE FIND_IN_SET($sub_category, sub_category_id) > 0