P22 使用轉(zhuǎn)碼字符將通配符轉(zhuǎn)義為普通字符

ESCAPE '\' 意思是\后面緊跟的字符為真正要查詢(xún)的字符

例如:查詢(xún)DB_Design課程的課程號(hào)和學(xué)分

select ... from ....

where Cname like 'DB_Design' ESCAPE '\'