Re: [sqlite] Compare Similar Cells

2013-09-23 Thread Kristopher Roy
Roger, Thank you, I will start working on it per your suggestions, though I would love to get mine cleaned up easily, I want to provide a solution that other users can use :) On Sun, Sep 22, 2013 at 11:14 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- >

Re: [sqlite] Compare Similar Cells

2013-09-23 Thread Stephen Chrzanowski
To the OP: I've got a tonne of media on my Drobo, and I feel your pain. Between my MP3s, pictures, videos and books, keeping tabs on file names, physical file locations, its quite the nightmare, and by the sounds of it, Roger has been exposed to this issue more so than I have been, and with my

Re: [sqlite] Compare Similar Cells

2013-09-23 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/09/13 19:41, Kristopher Roy wrote: > I have a table of songs, several have similar titles I can't find where > to get started. I tried this but its not right. Select SongTitle, > COUNT(SongTitle) AS LIKE_COUNT FROM Songs I did work with a

Re: [sqlite] Compare Similar Cells

2013-09-22 Thread Kristopher Roy
Lets say one songtitle is "Happy Day" and another one "12 - Happy Day" On Sun, Sep 22, 2013 at 8:28 PM, Igor Tandetnik wrote: > On 9/22/2013 10:41 PM, Kristopher Roy wrote: > >> I have a table of songs, several have similar titles I can't find where to >> get started. I

Re: [sqlite] Compare Similar Cells

2013-09-22 Thread Igor Tandetnik
On 9/22/2013 10:41 PM, Kristopher Roy wrote: I have a table of songs, several have similar titles I can't find where to get started. I tried this but its not right. Select SongTitle, COUNT(SongTitle) AS LIKE_COUNT FROM Songs What do you mean by "similar titles"? Show a representative sample of