'PostgreSQL: get all rows that contain an uppercase letter

How can I do the following stmt:

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

Solution 1:^[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

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1