79491873

Date: 2025-03-07 09:54:17
Score: 0.5
Natty:
Report link

I know this post is old but I had just came across the same situation as the OP. I did finally find this solution that helped me, I hope it helps others as well.

SELECT * FROM {TABLE_NAME} WHERE {FIELD} REGEXP '[^ -~]'

This will display all rows that have non-English characters. Be aware that it also will display rows if there is punctuation in the values.

Reasons:
  • Whitelisted phrase (-1): hope it helps
  • No code block (0.5):
  • Low reputation (1):
Posted by: Paul Denham