MySQL name LIKE '%#attributes.q#%' --- Doesn't return result for an exact match?
- by nobosh
I have the following MySQL query:
SELECT *
FROM customer
WHERE
fName LIKE '%#attributes.q#%' AND deleted = 'N'
OR
lName LIKE '%#attributes.q#%' AND deleted = 'N'
This works fine for guesses, but if you provide an exact match: "Bill Clinton" fname=bill lname = clinton to the query above you get 0 results?
How can this query be updated to…
