Re: [SQL] Finding strings inside a field...

|
|   SELECT * FROM streets WHERE street LIKE '%Zion%';
|
or even
    SELECT * FROM streets WHERE street ~ 'zion';
    SELECT * FROM streets WHERE street ~* 'ZiOn';

the second one is case insensitive....

    redax

.----------------------------------------------------------.
|Zsolt Varga            | tel/fax:   +36 36 422811         |
| AgriaComputer LTD     | email:     redax@agria.hu        |
| System Administrator  | URL:       http://www.agria.hu/  |
`----------------------------------------------------------'