How to use 'where' on column with comma separated values in laravel

Question

I am using php with laravel framework. I want to get rows from table that contains user id. Problem here is that user id is integer value and column(author) contain more than one comma separated integer values. Here is example.

DB::table('stories')->where('author','4')->get();

author column have values : row 1: 2,4,5 | row 2: 1,3,14 | row 3 : 4,5 and I will get row 1 and 3. So, Please help me to get right rows.

Narendrasingh Sisodia · Accepted Answer · 2015-11-03 08:36:39Z

28

You can use whereRaw like as

DB::table('stories')->whereRaw("find_in_set('4',author)")->get();

edited Nov 3, 2015 at 8:36

answered Nov 3, 2015 at 7:32

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

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

Comments

Narendrasingh Sisodia · Accepted Answer · 2015-11-20 09:21:30Z

3

First convert your string to array using

$row = "2,4,5";
$idsArr = explode(',',$row);  
DB::table('stories')->whereIn('author',$idsArr)->get();

edited Nov 20, 2015 at 9:21

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

answered Nov 3, 2015 at 7:36

PRANAV

6294 silver badges13 bronze badges

2 Comments

Narendrasingh Sisodia Over a year ago

Why to convert string into array if you can simply use find_in_set

PRANAV Over a year ago

@uchicha you are right..but different human has different mind and different mind has different way to logic... :)

Collectives™ on Stack Overflow

How to use 'where' on column with comma separated values in laravel

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related