How to use a percent (%) in a LIKE without it being treated as a wildcard?

You may use the LOCATE function, like so:

SELECT * 
FROM `001ProductList`
WHERE LOCATE('%', `programURL`) <> 0;

Escape the literal % character:

select * 
FROM 001ProductList
WHERE programURL LIKE '%\%%'

or use regex

WHERE programURL RLIKE '%'

Related