Hi All,

Username
========
AUbRian
AUCharles
AUdanny
AUcinDy
AUmichael

These are the sample records from my username field. It always start with 'AU', the problem now is lot of username that has capital letter and I need to sort out all username that only has CAPITAL inside(AUbRian, AUCharles, AUcinDy). Can anyone advise me the query to do that?
Thanks.

if you want to find only those names which has at list one upper case letter you can use regular expression function REGEXP_LIKE

ORACLE: DBA's day out: Use Regular Expressions in SQL

dear hasan_uiu

how confident are you that this oracle function will work correctly in mysql?

i'll bet you did not even realize that this was the mysql forum

tip: slow down and pay attention