Dear SQLiters, I have a table with examID column. When I try to select specific ID I have to use "like" instead of "=". Why is that? Why does not last SQL query produce nothing?
SQLite version 3.8.8.3 2015-02-25 13:29:11 sqlite> select examID, typeof(examID) from mainDB.Exam where mainDB.Exam.examID like '30'; examID typeof(examID) ---------- -------------- 30 integer sqlite> select examID, typeof(examID) from mainDB.Exam where mainDB.Exam.examID like 30; examID typeof(examID) ---------- -------------- 30 integer sqlite> select 'a'||examID||'a', typeof(examID) from mainDB.Exam where mainDB.Exam.examID like 30; 'a'||examID||'a' typeof(examID) ---------------- -------------- a30a integer sqlite> select 'a'||examID||'a', typeof(examID) from mainDB.Exam where mainDB.Exam.examID=30; sqlite> Thank you, Roman
