Skip to content

Instantly share code, notes, and snippets.

@dannguyen

dannguyen/value-lengths-dist-for-field.sql

Last active August 29, 2015 13:57
Show Gist options
  • Save dannguyen/9921769 to your computer and use it in GitHub Desktop.
Save dannguyen/9921769 to your computer and use it in GitHub Desktop.
Download ZIP
find distribution of value lengths for a given field
Raw
value-lengths-dist-for-field.sql
SET @field_name = "place_of_service";
SET @tablename = "payments";
SET @query = CONCAT('SELECT ', @field_name, ', count(1), length(', @field_name, ') AS lt FROM ', @tablename,' GROUP BY ', @field_name, ' ORDER BY lt desc');
PREPARE stmt FROM @query;
EXECUTE stmt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment