---
title: "ORACLE like 下划线 没作用"
author: "winzenghua"
date: "2009-08-24T17:35:00Z"
tags: []
slug: "oracle-like"
draft: false
lastmod: "2009-08-24T17:35:00Z"
id: 987861
url: "https://java4gis.iteye.com/blog/987861"
---

select ×

from user

where user\_name like 'esun\_%'

会出现 esun111 1231 等 下划线没有把这些排除掉

原来它也是通配符，所以要用 ORACLE中ESCAPE转意函数

where user\_name like 'esun\\\_%' escape'\\'

那就OK了

先用\\号告诉后面的是要处理的符合