vambroise/gist:32a3bc53d66b6095e6dc6e9d66f9196c

Forked from matoakley/gist:1092571

Created August 23, 2018 07:23

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/vambroise/32a3bc53d66b6095e6dc6e9d66f9196c.js"></script>
Save vambroise/32a3bc53d66b6095e6dc6e9d66f9196c 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