I have a table attribute with complete roads name. I have to search items by digiting a part of the road name and I need to colour all the items selected.
eg: ROAD NAME: / road 01 / road 02 / road 11 / road 12
I need to colour all items that contain "1" (so all the items except the second one). I would like to set the string operator is this way: ROAD NAME ILIKE ' * 1 * ' but it does not work
edit I work in advanced search in table attribute
Answer
if the attribute is called ROAD NAME, the query should be
"ROAD NAME" LIKE '%1%'
No comments:
Post a Comment