Extract BLOB from sqlite with command line [duplicate]

This question already has an answer here:

• How to dump a file stored in a sqlite database as a blob? 2 answers

I need to extract from a sqlite file a BLOB field (containing txt file) with command line.

How can I do it?