My company's enterprise directory is supposed to store all data fields
in English. Before the data standards were implmented, many of the
HR systems that fed data into the ED were sending some fields with a
combination of English and non-English characters. I want to identify
records with erroneous characters so we can ask the HR systems to
re-send the correct English-only values.
So...
I've exported a list of all users in the ED into a MySQL table called
'users'.
I would like to write a query that will return all records where the
'givenname' field contains one or more characters outside of [a-z] and
[A-Z]. I know I have to use REGEXP, but I can't figure out how to
find any record where one or more non-English characters exists in the
'givenname' field.
Thanks for your time
in English. Before the data standards were implmented, many of the
HR systems that fed data into the ED were sending some fields with a
combination of English and non-English characters. I want to identify
records with erroneous characters so we can ask the HR systems to
re-send the correct English-only values.
So...
I've exported a list of all users in the ED into a MySQL table called
'users'.
I would like to write a query that will return all records where the
'givenname' field contains one or more characters outside of [a-z] and
[A-Z]. I know I have to use REGEXP, but I can't figure out how to
find any record where one or more non-English characters exists in the
'givenname' field.
Thanks for your time