QGIS – How to Search Text String and Select Item in QGIS

field-calculatorqgis

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

"ROAD NAME" LIKE '%1%'