Re: search inside text column
You can use LOCATE() to look for string literals, LIKE to look for strings with wildcards, RLIKE | REGEXP to look for regular expressions (patterns). Which you need depends on what you're looking for. It might be best to start by reading about these search ops in the manual.
PB
Subject
Written By
Posted
Re: search inside text column
April 06, 2006 08:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.