和Oracle中一樣
WITH t AS
(
SELECT 'IT%' A FROM DUMMY UNION SELECT 'IT' FROM DUMMY
)
SELECT *
FROM t
WHERE a LIKE '%/%%' escape '/'
和Oracle中一樣
WITH t AS
(
SELECT 'IT%' A FROM DUMMY UNION SELECT 'IT' FROM DUMMY
)
SELECT *
FROM t
WHERE a LIKE '%/%%' escape '/'
![【MySQL資料庫】資料庫索引事務1.索引2.事務[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)