MySQL: What is a reverse version of LIKE?

by

Here’s a way you can achieve what you describe:

SELECT name FROM user 
WHERE 'John Smith and Peter Johnson are best friends' LIKE
  CONCAT('%', name, '%')

More Related Contents:

  1. Join vs. sub-query
  2. Find records from one table which don’t exist in another
  3. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  4. Natural Sort in MySQL
  5. MySQL get row position in ORDER BY
  6. Comparing date ranges
  7. Subqueries vs joins
  8. MySQL Results as comma separated list
  9. MySQL unknown column in ON clause
  10. MySQL not using indexes with WHERE IN clause?
  11. SQL: Find the max record per group [duplicate]
  12. Group by month and year in MySQL
  13. calculate a sum of type time using sql
  14. MySQL: Transactions vs Locking Tables
  15. Select TOP X (or bottom) percent for numeric values in MySQL
  16. How to create a multi-tenant database with shared table structures?
  17. MySQL #1140 – Mixing of GROUP columns
  18. MySQL select where column is not empty
  19. Hamming distance on binary strings in SQL
  20. Is it possible to have a default parameter for a mysql stored procedure?
  21. Renaming foreign-key columns in MySQL
  22. How to convert from varbinary to char/varchar in mysql
  23. MySQL GROUP BY behavior
  24. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  25. Update multiple rows with one query?
  26. What does collation mean?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment