[sqlite] very simple update query failure...

2010-02-10 Thread jflaming
I'm new to SQLITE. I'm trying to update a series of text entries for book titles that were entered with underscores. I want to convert them to spaces. I can run the query: select replace(title, '_', ' ') from books; and see the output I'm looking for, but if I try to do an update query

Re: [sqlite] very simple update query failure...

2010-02-10 Thread jflaming
Of course... apologies. I have tried this on command line sqlite 3 (3.6.22), sqlite 2.817, and also in the sqliteman gui and sqlite database browser, all on an Ubuntu linux box. P Kishor-3 wrote: On Wed, Feb 10, 2010 at 11:08 PM, jflaming jay.flam...@gmail.com wrote: I'm new to SQLITE