Level 73
You can't use SQL in a mongodb. You will have to use the query language of MongoDB .
Dec 23, 2021
7
Level 1
How to concat MySQL query into MongoDB
Hello Everyone!
How to combine first name and last name in Laravel, and I am using Mongo Database in db table i have two field first name and last name... i was using laravel eloquent query for fetching records
i was used sql concat but it's not working because of mongoDb
Here my Query
orWhere(\DB::raw("CONCAT(last_name, ' ', first_name)"), 'LIKE', "%".$search."%");
give me some suggestions please
Thank you in advance for your help
Level 1
@Tray2 sir, can you tell me how to do? in laravel
Level 102
@krackjack if you show a Mongo db example of what you want, then maybe we can help better
Level 73
@krackjack I don't use MongoDB. I can only suggest thet you switch to a RDBMS instead.
Level 1
@Sinnbeck Sir, see, i have listing page in this page i had combine firs name, last name when i search "Sinnbeck" i don't get any data but when i use Sinn then i got relevant data because in Mango data both filed are different
Level 1
Hii @tray2 @sinnbeck i am new in mongo db.. my question is i am using mongo db in backend.. in DB table i have a two field first name & last name and in laravel. i using eloquent query for fetching data and i want concat first name & last name..
i using a mongo package for laravel jenssegers/mongodb
Level 102
@krackjack mongodb syntax is very different from mysql/postgresql, so you will need to find out how to do it directly in Mongo db first. Sadly I don't use Mongo db (I prefer a relational database)
You can see examples of raw queries here : https://github.com/jenssegers/laravel-mongodb#mongodb-specific-operations
Please or to participate in this conversation.