SQL : Contoh Penggunaan Klausa Like di SQL

create database latihan
use latihan

create table barang
(
kode_brg varchar(5),
nama_brg varchar(15),
jumlah integer,
harga integer,
asal_supplier varchar(20)
)

insert into barang
    values('01','Mie','10','1000','Denpasar')
insert into barang
    values('02','Gula','30','7000','Banyuwangi')
insert into barang
    values('03','Keju','25','10000','Jakarta')
insert into barang
    values('04','Susu','20','35000','Jakarta')
insert into barang
    values('05','Kopi','80','9000','Denpasar')
insert into barang
    values('06','Teh','15','2000','Surabaya')
insert into barang
    values('07','Roti','40','5000','Bandung')

select nama_brg from barang where nama_brg like '%u'
select nama_brg from barang where nama_brg like 'r%'
select harga, nama_brg from barang where nama_brg like '%e%'