locvfx/gist:57e0633138d3abf09c9c59a1cd32f333

Forked from matoakley/gist:1092571

Created November 7, 2016 03:14

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/locvfx/57e0633138d3abf09c9c59a1cd32f333.js"></script>
Save locvfx/57e0633138d3abf09c9c59a1cd32f333 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