How to identify non English words using mysql Regexp?

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
mohit123
Posts: 162
Joined: Sat Sep 20, 2014 11:29 pm
Contact:

How to identify non English words using mysql Regexp?

Postby mohit123 » Mon Sep 14, 2015 11:51 pm

How to identify non English words using mysql Regexp?

How can I make my MySQL queries with regexp more intelligent so as to catch the any non English word hiding with the sentences?

REGEXP '^non-English$'

Thanks,


Guest

Re: How to identify non English words using mysql Regexp?

Postby Guest » Mon Sep 14, 2015 11:55 pm

below will find all kind of non English word. so you can run just delete for it.

column RLIKE '[[:<:]][^\u0000-\u007F]+[[:>:]]'


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 0 guests