I need a query to return item in Hotels_name that is ALL uppercase. Here is my attempt... mysql> select hotels_name,hotels_name REGEXP '[[:upper:]]' is_upper from hotels having is_upper=1 limit 10; +------------------------------------------------------+----------+ | hotels_name | is_upper | +------------------------------------------------------+----------+ | Delfin Siesta Mar | 1 | | Fairfield Bay Resort | 1 | | Holiday Inn Express Modesto | 1 | | Hotel Baronka Bratislava | 1 | | Resortquest Trappeurs S Crossing | 1 | | Roof at Spanish Steps Hotel | 1 | | Waldhotel Eskeshof | 1 | | Westbury Mayfair | 1 | | YWCA Montreal | 1 | | "Stirling Country House" Fine Mountain Accommodation | 1 | +------------------------------------------------------+----------+ 10 rows in set (0.00 sec)