Laravel-5 LIKE equivalent Eloquent

Question

I m using the below code to pull some results from the database with Laravel 5   BookingDates  where  email   Input  get  email   - gt orWhere  name    like   Input  get  name   - gt get     However  the orWhereLike doesn t seem to be matching any results   What does that code produce in terms of MySQL statements   I m trying to achieve something like the following   select   from booking dates where email  my email com  or name like   John

User · Answer

I think this is better  following the good practices of passing parameters to the query   BookingDates  whereRaw  email     or name like       request- gt email     request- gt name     - gt get      You can see it in the documentation  Laravel 5 5      You can also use the Laravel scout and make it easier with search    Here is the documentation

User · Answer

I have scopes for this  hope it help somebody  https   laravel com docs master eloquent local-scopes public function scopeWhereLike  query   column   value        return  query- gt where  column   like        value          public function scopeOrWhereLike  query   column   value        return  query- gt orWhere  column   like        value          Usage   result   BookingDates  whereLike  email    email - gt orWhereLike  name    name - gt get

User · Answer

data   DB  table  borrowers           - gt join  loans    borrowers id         loans borrower id           - gt select  borrowers      loans                - gt where  loan officers    like          officerId                - gt where  loans maturity date     lt    date  Y-m-d            - gt get

User · Answer

If you want to see what is run in the database use dd DB  getQueryLog    to see what queries were run   Try this  BookingDates  where  email   Input  get  email        - gt orWhere  name    like         Input  get  name         - gt get

[php] Laravel-5 'LIKE' equivalent (Eloquent)

Examples related to php

Examples related to mysql

Examples related to laravel-5