laravel query where in comma delimited string

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.

Abhishekh Gupta · Accepted Answer · 2015-06-06 08:40:25Z

2

You can use FIND_IN_SET():

WHERE FIND_IN_SET($sub_category, sub_category_id) > 0

answered Jun 6, 2015 at 8:40

Abhishekh Gupta

6,2464 gold badges21 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

sprintcar78a Over a year ago

Unfortunately that function is only returning if the exact number is stored and not if it is in the comma delimited string. i.e. it will return a sub_category_id of 2 in mysql table but not if it is 1,15,2 (this will be skipped). I need it so it will find all occurrences, any further suggestions?

Abhishekh Gupta Over a year ago

@sprintcar78a it is working fine. Check this fiddle. Better create a fiddle if you are still not getting desired o/p.

sprintcar78a Over a year ago

Ignore that I had $haystack, $needle NOT $needle, $haystack!! Back to the original deleted comment of thank you! :D

Collectives™ on Stack Overflow

laravel query where in comma delimited string

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related