0

I have this SQL query:

SELECT `firstname` FROM `table_xy` WHERE BINARY `firstname` LIKE '%ö%'

The problem with that is that it also finds items with o instead of ö such as

Motor
Völling
Hoeher

What do I have to change?

Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
Deen
  • 51
  • 13
  • By the way there is a mysql playground, https://sqlize.online/ where you can provide a complete working example instead of just some code – Your Common Sense Feb 24 '23 at 16:39

0 Answers0