MySQL Query Error
select count(*) as c from `student` WHERE 1=1 and is_display='Y' and (s_state='0')|(s_state='-1') AND (s_subject LIKE'%物理%' or 1=1 order by s_id)#%') ORDER BY s_id DESC
搜索框中输入授课科目为:
物理%' or 1=1 order by s_id)#最后报了上面的错误.上面那个语句好象没有语法错误啊?怎么mysql会提示出错呢?
select count(*) as c from `student` WHERE 1=1 and is_display='Y' and (s_state='0')|(s_state='-1') AND (s_subject LIKE'%物理%' or 1=1 order by s_id)#%') ORDER BY s_id DESC
搜索框中输入授课科目为:
物理%' or 1=1 order by s_id)#最后报了上面的错误.上面那个语句好象没有语法错误啊?怎么mysql会提示出错呢?
'''三个,单数