Skip to content

Instantly share code, notes, and snippets.

@rileypaulsen

rileypaulsen/Capitalize Field in MYSQL

Created July 10, 2013 20:40
Show Gist options
  • Save rileypaulsen/5970123 to your computer and use it in GitHub Desktop.
Save rileypaulsen/5970123 to your computer and use it in GitHub Desktop.
Download ZIP
capitalize the first letter of mysql entry
Raw
Capitalize Field in MYSQL
UPDATE wp_postmeta set meta_value = CONCAT(UCASE(SUBSTRING(meta_value, 1, 1)), LOWER(SUBSTRING(meta_value FROM 2))) WHERE meta_key='firstname'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment