How to Search Comma Separated Values in Laravel

Websolutionstuff | Sep-15-2021 | Categories : Laravel

Today, in this post i will show you how to search comma separated values in laravel. Here, we will find specific id from comma separated value and will get comma separated values from the table.

Here, we will search comma separated values using FIND_IN_SET() function. FIND_IN_SET() is predefine function of php mysql, here, we will use FIND_IN_SET() with whereRow() of laravel query builder for laravel comma separated search example. So let's see how to search comma separated values in laravel.

First of al we need to create 2 tables for find specific id from comma separated value. I have posts and tags tables in my website.

1) In posts table we have "ID", "name", "tag_id" 

2) In tags table we have "ID", "name"

Here, we will find records that have ID "1" from "tag_id" column of posts table.

$search_id = 1;
$data = \DB::table("posts")
    ->select("posts.*")
    ->whereRaw("find_in_set('".$search_id."',posts.tag_id)")
    ->get();

 

 

And you will get output like below.

Illuminate\Support\Collection Object
(
    [items:protected] => Array
    (
        [0] => stdClass Object
            (
                [id] => 1
                [name] => post1
                [tag_id] => 1,2
            )

        [1] => stdClass Object
            (
                [id] => 2
                [name] => post2
                [tag_id] => 1
            )
    )
)

 


 

You might also like :

Recommended Post
Featured Post
How To Install Vue JS 3 In Laravel 9
How To Install Vue JS 3 In Lar...

In this article, we will see how to install Vue JS 3 in laravel 9. Laravel is a web application framework with...

Read More

Oct-07-2022

How To Disable Weekends In jQuery Datepicker
How To Disable Weekends In jQu...

In this tutorial, we will see how to disable weekend dates in jquery datepicker. In the date picker, the weeke...

Read More

Jun-27-2022

Laravel 8 Group By Query Example
Laravel 8 Group By Query Examp...

In this example we will see laravel 8 group by query example. how to use group by in laravel 8. As you might expect...

Read More

Nov-29-2021

How To Block IP Address In Laravel 10
How To Block IP Address In Lar...

In this article, we will see how to block IP addresses in laravel 10. Here we will learn about how to restrict...

Read More

May-17-2023