View Single Post
Old 07-11-2018, 07:24 AM   #4
wjBLqf-_9
Connoisseur
wjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
Posts: 57
Karma: 12544
Join Date: Jul 2018
Device: None
So maybe my search-and-replace code "kung-foo" isn't as sharp as I wish

Using that search-and-replace window somehow managed to embed the title of the book ... within the tags of the book

in most of my library of 7,000 books
====
Honestly, I'm shy about using that window again unless I preface it with a filtering of book selection in the main window ahead of time
====
(full disclosure: I made a copy of the metadata.db file and explored the copy with SQLite Browser... this is my disposable copy)

Question for you (kovidgoyal) directly... just curious... what would happen if I manually deleted the rows with title text in the metadata.db/tags table?

Would the database see the missing rows and freak out or would there be corrective action -- interpreting the missing rows as negated tags?

~~~~
I figured deleting the rows in "tags" table would be easier than a higher complexity full-on-sql search syntax between the table relationships :-?
wjBLqf-_9 is offline   Reply With Quote