如题:
想在下面的语句中增加一个条件,即substring(visittime,10,2)等于08或者09都可以,怎么办?
sql="SELECT * FROM "+tableName+" where substring(CardID,1,2)='MT' and substring(visittime,10,2)='08'";
想在下面的语句中增加一个条件,即substring(visittime,10,2)等于08或者09都可以,怎么办?
sql="SELECT * FROM "+tableName+" where substring(CardID,1,2)='MT' and substring(visittime,10,2)='08'";
-- 或者:
sql="SELECT * FROM "+tableName+" where substring(CardID,1,2)='MT' and (substring(visittime,10,2)='09' or substring(visittime,10,2)='09')";