Re: [sqlite] quetion on editing a sqlite database

2013-09-17 Thread Markus Schaber
Hi, Von: von Simon Slavin > On 15 Sep 2013, at 11:30pm, john white wrote: > > Oh, there is a location column with this information. I can do them, > > one at a time, but that is going to take a LOT of time. I was hoping > > there would be a way to select them all and then

Re: [sqlite] quetion on editing a sqlite database

2013-09-16 Thread Simon Slavin
On 15 Sep 2013, at 11:30pm, john white wrote: > Oh, there is a location column with this > information. I can do them, one at a time, but that is going to take a LOT > of time. I was hoping there would be a way to select them all and then > simply do a find and replace

Re: [sqlite] quetion on editing a sqlite database

2013-09-16 Thread Tony Papadimitriou
See the REPLACE(x,y,z) function. Use UPDATE table SET field = REPLACE(field,) -Original Message- From: john white Sent: Monday, September 16, 2013 1:30 AM To: sqlite-users@sqlite.org Subject: [sqlite] quetion on editing a sqlite database I have a bit of a problem. I am moving

Re: [sqlite] quetion on editing a sqlite database

2013-09-16 Thread Stephan Beal
On Mon, Sep 16, 2013 at 12:30 AM, john white wrote: > An example would be: "C:\TV\" which should now be '/TV/". Even better > would > be to change all the "\" to "/" and then just delete the leading "C:". > The first solution i would try (thought possibly not the best

Re: [sqlite] quetion on editing a sqlite database

2013-09-16 Thread LMHmedchem
-- > If you reply to this email, your message will be added to the discussion > below: > http://sqlite.1065341.n5.nabble.com/quetion-on-editing-a-sqlite-database-tp71297.html > > To unsubscribe from SQ

[sqlite] quetion on editing a sqlite database

2013-09-16 Thread john white
uot; which should now be '/TV/". Even better would be to change all the "\" to "/" and then just delete the leading "C:". Thank you... -- View this message in context: http://sqlite.1065341.n5.nabble.com/quetion-on-editing-a-sqlite-database-tp71297.h