Query wildcards

Bart van den Eijnden bartvde at XS4ALL.NL
Mon Apr 10 10:03:58 EDT 2006


You should use regex to get that behaviour, for instance LIKE Z* would be:

EXPRESSION /^Z.*/

Have a look here regarding the case-insensitivity issue:

http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1381

Best regards,
Bart

> Hi all,
>
> Can anyone tell me how to use wildcards (or the SQL "like" command) in
> Mapserver queries? I can't seem to find anything about it...
>
> Also, the query seems to be case sensitive, I'd like this
> case-INsensitive. Is this possible?
>
> My current query is
> &qstring=('[KABELNAAM]'='RING7')
>
> but I'd like to have that
>
> &qstring=('[KABELNAAM]'='RING*')
> or something similiar.
>
> Any help would be greatly appreciated.
>
> Regards,
> Jelmer Baas
>



More information about the mapserver-users mailing list