Using Sqlite3, create a slug version of a full title -


i have sqlite3 database table. added column called title_slug. want take contents of title column, , update new title_slug column slug version. can straight sqlite3 or have code outside of program?

first of, there no loops in sqlite. not generic solution be:

update mytab set title_slug = replace(replace(title_slug, ' ', '-'), '!', '') 

but have add many chars replace ?!


Comments

Popular posts from this blog

php - How to build a web site which gives a sub-domain dynamically to every registered user? -

Delphi Wmi Query on a Remote Machine -