Skip to content

Instantly share code, notes, and snippets.

@eschmar

eschmar/queries.sql

Last active January 2, 2016 20:29
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 eschmar/8357139 to your computer and use it in GitHub Desktop.
Save eschmar/8357139 to your computer and use it in GitHub Desktop.
Download ZIP
Handy mysql queries
Raw
queries.sql
-- Average length of a text column
SELECT AVG(LENGTH(content)) AS length FROM `column` WHERE content!='';
-- Maximum length of a text column
SELECT MAX(LENGTH(content)) AS length FROM `column` WHERE content!='';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment