SQLite Forum

.mode html fails on html content
Login
This may be obvious and unhelpful, but for my need I just use

`.mode list`

And create my own HTML markup with:

`UPDATE myTable set ln = '<a href="' || ln || '">' || ln || '</a><br />'
       WHERE ln like 'http%';`

(Where "ln" is a text field with an entire line of output.)