[Qgis-user] QGis Query Builder

[Jacolin Yves]

Le Tuesday 25 August 2009 14:39:30 dassouki, vous avez écrit :
> Hey all,
>
> What is the best way to build a query in attribute table's search for
> the following statement:
>
> search in roads_layer where roads_id = *I*95*. * is a wild card
>
> I tried the LIKE "95", it returned a lot more data than i bargained for.
>
> cheers,
> dassouki
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

Try : LIKE '%I%95%'

Or read pattern search doc [1]
~ '^.I.95.' . symbol means one caracter. Use quantifiers : * for 0 or more 
time , + for 1 or more times

Regards,

Y.
[1] http://www.postgresql.org/docs/current/static/functions-matching.html
-- 
Yves Jacolin

Ne demandez pas si vous pouvez contribuer, contribuez ! :)
---
http://softlibre.gloobe.org