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
Laravel tips: DB Models and Eloquent - 2023
Laravel tips: DB Models and El...

Welcome to the fourth installment of our "Laravel Tips: DB Models and Eloquent" series. In this article, we co...

Read More

Oct-18-2023

How To Get Current User Location In Laravel
How To Get Current User Locati...

In this example, I will show you how to get the current user location in laravel, Many times we are required to find the...

Read More

Jun-10-2020

How To Check Occupied Disk Space In Laravel
How To Check Occupied Disk Spa...

Many times we need requirements to check the occupied disk space of the server on the admin side and we are checking man...

Read More

Jul-29-2020

Laravel 9 Create Middleware For XSS Protection
Laravel 9 Create Middleware Fo...

In this article, we will see laravel 9 create middleware for XSS protection. Cross-site scripting is a type of...

Read More

Apr-30-2022