Skip to content

Instantly share code, notes, and snippets.

@salgua

salgua/gist:5038995

Last active December 14, 2015 05:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save salgua/5038995 to your computer and use it in GitHub Desktop.
Save salgua/5038995 to your computer and use it in GitHub Desktop.
Download ZIP
with this MySQL query you can extract rows that contain in the field "textfield1" only uppercase words
Raw
gistfile1.sql
#with this query you can extract rows that contain in the field "textfield1" only uppercase words
SELECT * FROM t1 WHERE BINARY textfield1 = ucase(textfield1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment