Laravel-5 ‘LIKE’ equivalent (Eloquent)

by

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'))
    ->orWhere('name', 'like', '%' . Input::get('name') . '%')->get();

More Related Contents:

  1. Laravel 5 PDOException Could Not Find Driver
  2. How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
  3. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  4. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  5. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  6. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  7. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  8. How can I do a migration in laravel 5.5?
  9. CONCAT columns with Laravel 5 eloquent
  10. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  11. find in set in laravel ? example
  12. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  13. How to properly set up a PDO connection
  14. Using PHP 5.5’s password_hash and password_verify function
  15. Search with comma-separated value mysql
  16. How to do this in Laravel, subquery where in
  17. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  18. PHP MySQLI Prevent SQL Injection [duplicate]
  19. mysql PDO how to bind LIKE
  20. Does mysql_real_escape_string() FULLY protect against SQL injection?
  21. how to access the command line for xampp on windows
  22. PHP, MySQL and Time Zones
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Password_Hash not working on my PHP login
  25. Formatting an SQL timestamp with PHP
  26. Select mySQL based only on month and year
  27. Mysql InnoDB engine in Laravel
  28. MySQL: Group by two columns and sum
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment