Home » RDBMS Server » Server Administration » Re: search for '%' or '_' patterns
Re: search for '%' or '_' patterns [message #372611] Tue, 27 February 2001 12:00
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
Assumiing Table A contains values
'aa'
'bb'
'%c'
'd%'
'ee'
'xx_yy'

Try the following queries:
select col1 from a
where col1 like '%\_%' escape '\';

select col1 from a
where col1 like '%\%%' escape '\';

Report message to a moderator

Previous Topic: Constraint problem
Next Topic: Re: search for '%' or '_' patterns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:32:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.