SELECT SCH_NAME FROM SCH_INFO WHERE SCH_NAME = ‘%清华%’; --错误的用法 = 是精确匹配
SELECT SCH_NAME FROM SCH_INFO WHERE SCH_NAME LIKE ‘%清华%’; – LIKE配合通配符 是模糊查询
oracle模糊查询
最新推荐文章于 2024-06-11 17:55:55 发布
SELECT SCH_NAME FROM SCH_INFO WHERE SCH_NAME = ‘%清华%’; --错误的用法 = 是精确匹配
SELECT SCH_NAME FROM SCH_INFO WHERE SCH_NAME LIKE ‘%清华%’; – LIKE配合通配符 是模糊查询