Remove html tags, entities, characters... from a SQLite table

Is easy, you only have to use this command:

update table SET column = replace(column, "&nbsp", " ");

And the combinations you want:

update table SET column = replace(column, "&aacute", "á");

...

More info on: http://www.sqlite.org/lang_corefunc.html
Remove html tags, entities, characters... from a SQLite table Remove html tags, entities, characters... from a SQLite table Reviewed by Ricardo Castellanos on 11:16 Rating: 5

No hay comentarios:

Con la tecnología de Blogger.