Image string select in sql server table

1

Hi All,

my tbale have a 150000 records i this records some of records have images.how can i select only image records from table .
For example my table like this.

high heels
:light_rail:
high heel wedges
high heeled boots
:tram:
:oncoming_bus:
high heels boots for women
heysham port train station parking
:trolleybus:
:minibus:
:oncoming_police_car:
hga group

Final i want the only image records like
:light_rail:
:tram:
:oncoming_bus:
:trolleybus:
:minibus:
:oncoming_police_car:

Regards
Pols

2

Please provide DDL for the table and insert statement(s) with sample data.