[Beastmode] Like binary - to find uppercase text
When I use the following (example) query it's working fine:
(case when `Product` like '%PROduct1%' then 'Productone' else 'Ignore' end)
Except that product1 also turns up in my results and I only want PROduct1 which uses uppercase letters.
In mysql you can use "like binary" but when I change it to:
(case when `Product` like binary '%PROduct1%' then 'Productone' else 'Ignore' end)
it gives me a syntax error.
Any solution to this?