I have a table called stock, I have a sql statement to list the stock record, the question is :
is it to find the record that match certain word like "BRG" for example

stockcode description
STOCK A BRG A
STOCK B A BRG
STOCK V V DESCRIPTION
STOCK G G DESCRIPTION0
STOCK J J BRG

I want to list description that contain BRG so the result is

STOCK A BRG A
STOCK B A BRG
STOCK J J BRG


How to list using the SQL statement ?

Sorry for my english