Yogesh Marwaha wrote: > Hi! > > I am using sqlite 3.05 beta. I have created a table containing a field named > 'title'. When I run the SQL Command : - > > select count(*) from master_table where title = "title" > > output is 885, i.e. count of all the rows in the table, whereas it should > have returned the number of rows in which value of the field title is "title" > (which is actually 10). Perhaps sqlite is comparing value of column named > title with the column itself. >
A string in double-quotes resolves to the name of a column if such a column is available. Use single-quotes to force the string to be interpreted as a string.
SELECT count(*) FROM master_table WHERE title='title'; ^ ^ | | ' not " here -^-----'
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565