As I understand your inquiry, now that you have clarified it, your post is not really off-topic. (It just looks that way. ;-) If you study the <u>[UPDATE SYNTAX](https://sqlite.org/lang_update.html)</u>, you will see exactly how to do what you wish to accomplish in SQLite.