|
| 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(at)agria(dot)hu |
| System Administrator | URL: http://www.agria.hu/ |
`----------------------------------------------------------'