[Qgis-user] QGis Query Builder
Jacolin Yves
yjacolin at free.fr
Tue Aug 25 05:44:07 PDT 2009
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
More information about the Qgis-user
mailing list