Search code examples
mysqlsearchidentity-columnnon-english

MySQL Table Column has English values or Arabic

I have one table in MySQL which stores clients information. There are two description info columns like CLIENT_DETAIL_INFO and CLIENT_DETAIL_INFO_A

There are more than 5 thousand records under clients table.

What I want is, to identify Arabic column CLIENT_DETAIL_INFO_A - and it contains English records, not Arabic values in that column.

How can I identify and prepare a list of primary id of such records?

Please suggest.

Solution

  • One Way

    You can identify based on its REGEXP 

    SELECT CLIENT_DETAIL_INFO_A  FROM tableName WHERE NOT CLIENT_DETAIL_INFO_A  REGEXP '[A-Za-z0-9]';

    for reference

    http://dev.mysql.com/doc/refman/5.1/en/regexp.html

    Another Way

    Based on unicode value like for arabic range is 0600 - 06E0

    for reference

    http://www.tamasoft.co.jp/en/general-info/unicode.html