On Feb 11, 2010, at 12:08 PM, jflaming wrote:
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 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
On Wed, Feb 10, 2010 at 11:08 PM, jflaming jay.flam...@gmail.com wrote:
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;
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.
