Use the *~ operator as described at: http://www.postgresql.org/docs/8.3/static/functions-matching.html
Steve >>> "Sven Schroeter" <[EMAIL PROTECTED]> 09/24/08 5:12 AM >>> Hi all, I'm using the queryByAttributes-function of PHP-Mapscript with the LIKE (~) operator for strings (out of a POSTGIS-table): $queryString = "nom_bande ~ 'WT'"; $queryItem = "nom_bande"; @$datQuery = $layer->queryByAttributes($queryitem,$queryString,MS_MULTIPLE); Every dataset that contains 'WT' comes as result. But this is case sensitive, if I try $queryString = "nom_bande ~ 'wt'"; there is no result. Is it possible to make the query case insensitive? Thanks Sven _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
