Skip to content

Instantly share code, notes, and snippets.

@himanshu219

himanshu219/gist:f8b2d4317abc75e96601d243e29d54ca

Forked from matoakley/gist:1092571
Created April 11, 2016 11:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save himanshu219/f8b2d4317abc75e96601d243e29d54ca to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save himanshu219/f8b2d4317abc75e96601d243e29d54ca to your computer and use it in GitHub Desktop.
Download ZIP
MySQL to convert a string into a slug
Raw
gistfile1.txt
LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM('My String'), ':', ''), ')', ''), '(', ''), ',', ''), '\\', ''), '\/', ''), '\"', ''), '?', ''), '\'', ''), '&', ''), '!', ''), '.', ''), ' ', '-'), '--', '-'), '--', '-')) AS `post_name`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment