Re: [sqlite] Compare Similar Cells

2013-09-23 Thread Kristopher Roy
-- > 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 wor

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 <i...@tandetnik.org> wrote: > On 9/22/2013 10:41 PM, Kristopher Roy wrote: > >> I have a table of songs, several have similar titles I

[sqlite] Compare and INSERT INTO syntax issue

2013-09-22 Thread Kristopher Roy
I am trying to grab the value of custom5 % and compare it to skipcount and then if it is a higher value write it to skipcount, but something is wrong with my syntax, can anyone help? INSERT OR REPLACE INTO SONGS (skipcount) Values SELECT substr( custom5, 1, 4) FROM SONGS WHERE custom5 >