westhouseit/gist:dd21ac7e1b62e1b122e8150df13c38d6

Forked from matoakley/gist:1092571

Created September 29, 2019 20:55

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/westhouseit/dd21ac7e1b62e1b122e8150df13c38d6.js"></script>
Save westhouseit/dd21ac7e1b62e1b122e8150df13c38d6 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