FreeThreads
Published in

FreeThreads

SQL Inserting JSON value of HTML String with Tags into Table

  1. Stringify the JSON to one line. I used the JSON to a one-line converter.
  2. Insert the String value with ’’ character.
UPDATE configuration SET val='{"title":"<b>A bold title</b>"}'

The value must be enclosed in '’ characters.

Things to Remember

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Simplify Complexity

Simplify Complexity

Golang, Distributed Systems, File Systems, Python, C/C++, Linux