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
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
>
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
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 > '%
4 matches
Mail list logo