MySQL SELECT query string matching

September 11, 2023 by Tarik

Just turn the LIKE around

SELECT * FROM customers
WHERE 'Robert Bob Smith III, PhD.' LIKE CONCAT('%',name,'%')