Throwing a wild idea out: Can you try using single-quotes (e.g. "...where dancename = 'Waltz'..."). Single-quotes are meant to be used for text-literals; double-quotes are meant to "protect" field/table names where they clash with keywords (or contain "odd" characters). Additionally, do you by any chance have a field called "Waltz" in your table?
Tuesday, June 04, 2019, 7:26:12 PM, Doug <[email protected]> wrote: > Sqlite version is 3.27.1. > I have no indexes defined. > Here is a query I just ran from bash: > select songfile_id,dancename,dancegroupname from songfiletable where > songfile_id=377; > 377|Waltz|American Smooth > ... and another: > select songfile_id,dancename,dancegroupname from songfiletable where > dancename like "Waltz"; > 377|Waltz|American Smooth > 388|Waltz|American Smooth [snip] > ... and yet another: > select songfile_id,dancename,dancegroupname from songfiletable where > dancename = "Waltz"; sqlite>> > Nothing selected using "=". _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
