Advertisement
Guest User

Untitled

a guest
Sep 30th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. UPDATE schools SET
  2. slug = lower(name),
  3. slug = replace(slug, '.', ' '),
  4. slug = replace(slug, '\'', ''),
  5. slug = trim(slug),
  6. slug = replace(slug, ' ', '-'),
  7. slug = replace(slug, '--', '-');
  8. UPDATE schools SET
  9. slug = replace(slug, '--', '-');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement