Use single quotes, not double. Double quotes are used for identifiers, not
strings, so that matches rows where id and description have the same value.
On Wed, Nov 28, 2018, 1:19 AM Dale Mellor <sqlite-22p...@rdmp.org wrote:
> >>>>>>>> THIS VERSION
> SQLite 3.25.3 2018-11-05 20:37:38
> 89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b750alt1
> zlib version 1.2.8
> gcc-8.2.0
>
>
> >>>>>>>>> THIS SCRIPT
> create table test (id varchar, description varchar);
> insert into test (id, description) values ("Description", "Duh");
> insert into test (id, description) values ("Daft", "Daft");
> select rowid, * from test where id="Description";
>
>
>
> >>>>>>>>>> PRODUCES
> 2|Daft|Daft
>
>
>
> >>>>>>>>>> BUT EXPECTED
> 1|Description|Duh
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
