PostgreSQL: get all rows that contain an uppercase letter

Question

How can I do the following stmt:

select * from table
where column has any uppercase letters; <-- how to write this

Answer 1

You can filter with a regex:

select * 
from mytable
where mycolumn ~ '[A-Z]'

Another approach is string comparison:

select * 
from mytable
where lower(mycolumn) <> mycolumn