Re: [sqlite] Compare Similar Cells

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

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 >

[sqlite] Compare Similar Cells

2013-09-22 Thread Kristopher Roy
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 -- Thank You, TankCR ___ sqlite-users mailing list sqlite-users@sqlite.org

[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 > '%