RakibSiddiquee/makeSlugMySql.sql

Created January 21, 2019 11:04

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/RakibSiddiquee/440cb46860e1aeb5f6015011f4dd5f9a.js"></script>
Save RakibSiddiquee/440cb46860e1aeb5f6015011f4dd5f9a to your computer and use it in GitHub Desktop.

Download ZIP

Make slug of a column in MySQL database and update

Raw

makeSlugMySql.sql

UPDATE table SET domain = LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(name), ':', ''), '’', ''), ')', ''), '(', ''), ',', ''), '\\', ''), '\/', ''), '\"', ''), '?', ''), '\'', ''), '&', ''), '!', ''), '.', ''), ' ', '-'), '--', '-'), '--', '-'))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment