Search code examples
mysqlsql-like

mysql like string which contains %

I created a database for newsletter and i save campaigns. Also i add campaign code in customer table. for example i have a campagin with code "collagen" ana code "solgar-51%" and i save it in emailcampaign column "collagen, solgar-51%". Some customer have both of them. I want emailcampaign column like end of "solgar-51%".

This work

SELECT * 
FROM  `customer` 
WHERE  `emailcampaign` LIKE  '%solgar -51%%'

but this NOT

SELECT * 
FROM  `customer` 
WHERE  `emailcampaign` LIKE  'solgar -51%%'

neither this

SELECT * 
FROM  `customer` 
WHERE  `emailcampaign` LIKE  'solgar -51%%'
Solution

  • Try \%:

    SELECT * 
FROM  `customer` 
WHERE  `emailcampaign` LIKE  '%solgar -51\%'