oracle问题：select语句中如何实现sqlserver中得通配符查询？

[coolicer]

比如在sqlserver中：
select * from mytable where col1 like 'firstname[_]lastname'
oracle中如何实现

[KingSunSha]

ORACLE的通配符是%和_,前者可匹配多个字符,后者是一个.
和SQL SERVER一样的

[dmyb7233]

Syntax

match_expression [NOT] LIKE pattern [ESCAPE escape_character]

Arguments

match_expression

Is any valid SQL Server expression of character string data type.

pattern

Is the pattern to search for in match_expression, and can include these valid SQL Server wildcard characters.

Wildcard character Description Example
% Any string of zero or more characters. WHERE title LIKE ?computer%?finds all book titles with the word 慶omputer?anywhere in the book title.
_ (underscore) Any single character. WHERE au_fname LIKE 慱ean?finds all four-letter first names that end with ean (Dean, Sean, and so on).
[ ] Any single character within the specified range ([a-f]) or set ([abcdef]). WHERE au_lname LIKE 慬C-P]arsen?finds author last names ending with arsen and beginning with any single character between C and P, for example Carsen, Larsen, Karsen, and so on.
[^] Any single character not within the specified range ([^a-f]) or set ([^abcdef]). WHERE au_lname LIKE 慸e[^l]%?all author last names beginning with de and where the following letter is not l.

[coolicer]

我是说屏蔽通配符，比如
我要查找zhang_wei的名字
在sqlserver中
select * from mytable where name like 'zhang[_]wei'
而不是查找
zhang1wei,zhangkwei等等

[szsusuia]

直接用：
select * from mytable where name like 'zhang_wei';　不就行了。

[mashansj]

select * from mytable where name like 'zhang\_wei' escape '\';

[sbm]

同意楼上的.