SQL query to search records

Joicy Sunny

9y1kSQL

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tanmay Hajra9y ago
Accepted answer
Joicy.. You can try this :
Select * from tbl_Test tbl
where tbl.Name like 'OIL %' or tbl.Name like '% OIL %' or tbl.Name like '% OIL'
Thiruppathi R9y ago
It is a simple one

SELECT ID,NAME FROM TBL_TEST WHERE NAME LIKE '%OIL%'

it will getting exjact result
Nilesh Shah9y ago
select * from tbl_Test t where
t.Name like '%oil%'

May be you should try this

select * from tbl_Test where Name = 'OIL';