MySQL Query with Lowercase Flag

I recently needed to provide an export of string values in a MySQL table that began with a lower case letter.

This query will produce 3 columns: id, name, and lowercase. Rows that begin with a lower case letter will have a 1 in the lowercase column.

SELECT id, name, 
    IF ((BINARY UPPER(SUBSTRING(name, 1, 1 )) = BINARY (SUBSTRING(name, 1, 1))) , "", "1") AS lowercase
  From mytable 
  WHERE name;