--
> 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
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
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 >
3 matches
Mail list logo