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
像上方是兩種完全不同的結果赂苗，想表達式達到預期的效果阳惹。則字段與值一樣的寫法租悄。單引號要有都有，沒有單引號就都不要寫單引號
2 sqlite多種排序方式另玖，直接是不同字段逗號隔開困曙。如：select * from menu order by dish_time,menu_name desc
