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 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 data > in your table, and the result you would like to obtain from the query when > run on that sample. > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- Thank You, Kristopher C. Roy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
