Mysql check if lowercase

-- will detect all names that are not in uppercase
SELECT 
    name, UPPER(name) 
FROM table 
WHERE 
    BINARY name <> BINARY UPPER(name)
;

-- will detect all names that are not in lowrcase
SELECT 
    name, UPPER(name) 
FROM table 
WHERE 
    BINARY name <> BINARY LOWER(name)
;

Source: stackoverflow.com

Similar codes

0 vote273 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote300 views1 answer
Update sql sintax
SQL
0 vote280 views1 answer
Rabbitmq ui not working
SQL
29 votes274 views6 answers
Delete all rows from table mysql
SQL
2 votes267 views1 answer
Oracle cpu per session
SQL
0 vote303 views1 answer
Postgres change the name of schema
SQL
0 vote282 views1 answer
Sql select most frequent value in column
SQL
0 vote304 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote324 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote274 views1 answer
How to write triggers to increment or decrement the number of employees
SQL