1 SELECT * FROM menu WHERE dish_time < 'datetime("now", "localtime", "start of day")' AND finish_state = 2

SELECT * FROM menu WHERE 'dish_time' < 'datetime("now", "localtime", "start of day")' AND finish_state = 2

像上方是兩種完全不同的結(jié)果，想表達式達到預期的效果。則字段與值一樣的寫法。單引號要有都有，沒有單引號就都不要寫單引號

2 sqlite多種排序方式，直接是不同字段逗號隔開。如：select * from menu order by dish_time,menu_name desc