ORACLE: 含通配符的模糊查询

Question

SELECT count(*)
FROM MSG_SEND
WHERE STATUS = '1'
AND SEND_ID = '210000000004843'
AND CONTENT like '%_%'
AND SEND_TIME >= to_date('2013-08-02 00:00:00','YYYY-MM-DD HH24:Mi:SS')
AND SEND_TIME <= to_date('2013-08-22 23:59:59','YYYY-MM-DD HH24:Mi:SS')
escape '\'
执行上面语句的时候会报“命令未正确结束“这种错误

而下面的语句可以正常执行
SELECT count(*)
FROM MSG_SEND
WHERE STATUS = '1'
AND SEND_ID = '210000000004843'
AND SEND_TIME >= to_date('2013-08-02 00:00:00','YYYY-MM-DD HH24:Mi:SS')
AND SEND_TIME <= to_date('2013-08-22 23:59:59','YYYY-MM-DD HH24:Mi:SS')

Answer 1

SELECT count(*)
FROM MSG_SEND
WHERE STATUS = '1'
AND SEND_ID = '210000000004843'
AND CONTENT like '%_%' escape '\'
AND SEND_TIME >= to_date('2013-08-02 00:00:00','YYYY-MM-DD HH24:Mi:SS')
AND SEND_TIME <= to_date('2013-08-22 23:59:59','YYYY-MM-DD HH24:Mi:SS')

你escape用错地方了，要跟在like语句后面的