Search Query

Shinto · #1 (**permalink**) 03-31-04, 20:03

I have the following table called Test with the following columns.

Items
---------
pest
best
test
destruct

Is there anyway of selecting everything in the table if i do a search for est? Meaning, i wanna select any items containing 'est'. Is there a possible SQL statement for it? Thanks.

Marcus_A · #2 (**permalink**) 03-31-04, 20:52

use the LIKE statement:

where column-name like '%est%'

See the SQL Reference for more details on LIKE and the use of % and _.

hurmavi · #3 (**permalink**) 04-02-04, 01:07

Quote:

Originally posted by Marcus_A
use the LIKE statement:

where column-name like '%est%'

See the SQL Reference for more details on LIKE and the use of % and _.

Hi

One word of caution. Doing a search like that into big table will cause an index space scan & a major performance 'hog'. We have one like this in our company (OS/390 environment), and it's a real PROBLEM.

Cheers, Bill

Shinto · #4 (**permalink**) 04-02-04, 01:09

Thanks for the caution.

Internet Services

Web Development

Digital Marketing

Consumer Tech