Alternative to the LIKE command

From: OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply <OakRogbak_erPine_at_yahoo.com>
Date: 11 Feb 2004 14:12:09 -0800
Message-ID: <13fdc9b4.0402111412.431115cd@posting.google.com>

One of our developers is trying to figure out how to search a string for a partial match. In other words, if you had a table such as

NAME (Varchar2)       TIDS (varchar2)
---------------       --------------
Joe Black            
123123,432432,324234,764565,4334534,344353,45715435,35338
Ben Hur              
123756,324342,8237482,975924,145238,2934283,2348248,23423
Tom Thumb            

872834,93124,873247,092243,23432,823472,29349,7502849

Is there another way to rewrite

select NAME from MYTABLE where TIDS like '%324234%';

so that you get better performance, assuming a great number of rows? Can the owa_pattern.match be used here?

Thanks. Received on Wed Feb 11 2004 - 16:12:09 CST