TheHiddenHaku/gist:70a0c94585956442ecdc141cf1cd3667

Forked from matoakley/gist:1092571

Created May 29, 2018 16:26

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/TheHiddenHaku/70a0c94585956442ecdc141cf1cd3667.js"></script>
Save TheHiddenHaku/70a0c94585956442ecdc141cf1cd3667 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