How to use a user variables in MySQL LIKE clause?

by 
SET @email="[email protected]";

SELECT email from `user` WHERE email LIKE CONCAT('%', @email, '%');

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. How to select the nth row in a SQL database table?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. How to do a batch insert in MySQL
  7. Count the occurrences of DISTINCT values
  8. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  9. Storing JSON in database vs. having a new column for each key
  10. How do I restore a dump file from mysqldump?
  11. Cast int to varchar
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. Import SQL file into mysql
  15. How to change the default port of mysql from 3306 to 3360
  16. Does mysql have the equivalent of Oracle’s “analytic functions”?
  17. How to skip certain database tables with mysqldump?
  18. “where 1=1” statement [duplicate]
  19. How to set a MySQL row to READ-ONLY?
  20. MySQL: LAST_INSERT_ID() returns 0
  21. Using reserved words in column names
  22. Calculating a Moving Average MySQL?
  23. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  24. How to insert a file in MySQL database?
  25. Strings as Primary Keys in MYSQL Database [closed]
  26. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  27. FIND_IN_SET with multiple value [duplicate]
  28. What is the difference between SQL and MySQL? [closed]
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment