Some time you get recird from comma separated values in sql. for example you craete one users module and this user know multiple language like english, france, hindi, italian etc..., so, some time to get only that type records whcih user know english.
So we have hew one language table like that
language table
+----+---------+
| id | name |
+----+---------+
| 1 | english |
+----+---------+
| 2 | hindi |
+----+---------+
And we have one another table in this table we have store user information like that
users table
+----+-------------+----------+
| id | language_id | name |
+----+-------------+----------+
| 1 | 1,2 | john doe |
+----+-------------+----------+
| 2 | 1 | Hanry |
+----+-------------+----------+
| 3 | 2 | Harry |
+----+-------------+----------+
[ADDCODE]
Now we are required only that user which know english, then here we are getting 2 user name. 1.john and 2. Hanry. so how to done this type query in laravel. it is posible with in laravel using find_in_set() like that
$data \DB::table("users.*")
->whereRaw("find_in_set('2',language_id)")
->orderBy("users.id","asc")
->get();
Then we are geting like that result
+----+-------------+----------+
| id | language_id | name |
+----+-------------+----------+
| 1 | 1,2 | john doe |
+----+-------------+----------+
| 2 | 1 | Hanry |
+----+-------------+----------+
We are hope this small tutorials is helpfull to you.....
Hi, My name is Harsukh Makwana. i have been work with many programming language like php, python, javascript, node, react, anguler, etc.. since last 5 year. if you have any issue or want me hire then contact me on [email protected]
How to Generate Unique slug in Laraval 7.x Example
Want to engender unique slug in Laravel?...How to Get the Class Name of an Object in JavaScript
Use the name Property You can use the...How to run a php script in the background
While working in PHP project, sometimes...How to make HTTP GET and POST Request in ReactJs using Axios
In this React Axios tutorial, we ar...How to Allow Only Numeric Value in HTML Text Input Using jQuery
Use the RegExp test() Method If you w...