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
Best Answer
if the attribute is called ROAD NAME, the query should be