I would like a mysql query. All the fields which contain a capital letter

Question

I have a little trouble with this query and google is not my friend today

I all the results of a table that contains one or more capital letters. Something like this:

SELECT * FROM personal_urls WHERE CONTAINS_UPCASE(vanity_url)

Somebody knows an easy solution for this?

Thanks!

Answer 1

try

        SELECT * 
        FROM personal_urls 
        WHERE CAST(vanity_url  AS BINARY) RLIKE '[A-Z]';

Answer 2

I think RLIKE string function can help. We may use regexp [A-Z] to test string for capital letters.