On Wed, Apr 03, 2013 at 02:28:07PM +0200, Dominique Devienne scratched on the wall: > On Wed, Apr 3, 2013 at 1:54 AM, Support <apps...@gmail.com> wrote: > > > sqlite3 -line ~/Desktop/maps.db 'select * from airports where LocationID > > like "USE%";' > > I get correct result. > > > > But when I call > > sqlite3 -line ~/Desktop/maps.db 'select * from airports where > > LocationID=="USE";' > > > > SQL uses =, not == (and string literals are in single-quotes, just in > case). --DD
True, although SQLite supports several additional C style operators, including "==", to keep us all from going crazy. Perhaps not a good habit to get into, but perfectly valid for SQLite: http://www.sqlite.org/lang_expr.html Note that there are two variations of the equals and not equals operators. Equals can be either = or ==. The non-equals operator can be either != or <>. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users