Thread: Using SQL against Calibre database
View Single Post
Old 03-29-2010, 09:33 AM   #1
jjansen
J
jjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterjjansen can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
Posts: 188
Karma: 12590
Join Date: Mar 2009
Location: Canada
Device: SONY PRS 505/300, iRex DR800SG, Nook
Using SQL against Calibre database
Is there someway that I can achieve the following function against the Calibre database.

Update Calibre Set COMMENT = 'new text string' concat COMMENT
where publisher = 'Ramsay House'

I want to bulk add some text to the COMMENT field for a specific publishers records.

Thanks.......Jackie
jjansen is offline   Reply With Quote