tbl_Test contains the following records
Id Name
1 OIL FILTER COLLAR
2 FORK OIL SEAL KIT
3 IGNITION COIL
4 OIL FILTER ELMENT
5 ENGINE OIL
6 OILLION HOLDING TUBE
I need to select records where the Name contains the exact word "Oil"
that is, required output is
Id Name
1 OIL FILTER COLLAR
2 FORK OIL SEAL KIT
4 OIL FILTER ELMENT
5 ENGINE OIL