Using mysql concat() in WHERE clause?

by

What you have should work but can be reduced to:

select * from table where concat_ws(' ',first_name,last_name) 
like '%$search_term%';

Can you provide an example name and search term where this doesn’t work?

More Related Contents:

  1. How to update multiple MySQL table entries with different id?
  2. Can’t insert data into mysql database using PHP [closed]
  3. which is better every user have a table or just a row [closed]
  4. How can I use PDO to fetch a results array in PHP?
  5. Fixing broken UTF-8 encoding
  6. MySQL check if a table exists without throwing an exception
  7. Export MySQL data to Excel in PHP
  8. MySQL – ignore insert error: duplicate entry
  9. Calculate age based on date of birth
  10. How to write a stored procedure using phpmyadmin and how to use it through php?
  11. “slash before every quote” problem [duplicate]
  12. Doing calculations in MySQL vs PHP
  13. Geo-Search (Distance) in PHP/MySQL (Performance)
  14. Call to a member function execute() on boolean in [duplicate]
  15. PHP mysql search multiple tables using a keyword
  16. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  17. How to store the data in unicode in hindi language
  18. PDO + MySQL and broken UTF-8 encoding
  19. Best practice: Import mySQL file in PHP; split queries
  20. Connecting to remote MySQL server using PHP
  21. Using PHP to execute multiple MYSQL Queries
  22. Base table or view not found: 1146 Table Laravel 5
  23. How would I implement a simple site search with php and mySQL?
  24. Check for duplicates before inserting
  25. How to run multiple insert query in SQL using PHP in one go?
  26. mysqli_affected_rows in PHP insert
  27. PHP MySQL set Connection Timeout
  28. Sort by date (newest)
  29. The ultimate emoji encoding scheme
  30. mysql count occurrences of special character in a field

Leave a Comment