Joicy Sunny

Joicy Sunny

  • NA
  • 52
  • 10.2k

SQL query to search records

May 23 2017 12:15 PM
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
 
 
 

Answers (4)