因为在SQL中下划线也当作了单个的通配符,所以返回的结果是:
select * from T_MQlog where F_Type like 'Ticket[_]%'
select * from T_MQlog where F_Type like 'Ticket/_%' escape '/'
因为在SQL中下划线也当作了单个的通配符,所以返回的结果是:
select * from T_MQlog where F_Type like 'Ticket[_]%'
select * from T_MQlog where F_Type like 'Ticket/_%' escape '/'