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 :
In this article, we will see how to install Vue JS 3 in laravel 9. Laravel is a web application framework with...
Oct-07-2022
In this tutorial, we will see how to disable weekend dates in jquery datepicker. In the date picker, the weeke...
Jun-27-2022
In this example we will see laravel 8 group by query example. how to use group by in laravel 8. As you might expect...
Nov-29-2021
In this article, we will see how to block IP addresses in laravel 10. Here we will learn about how to restrict...
May-17-2023