'regex with column name in where condition

I've to find matching records from the user search history table like below.

search_history Table

name (column - string):
------------
bla
bla bl
bla bla
bl
other
othe

Is there a way to query the table like,

Get all search history related to 'bla bla' matching (expected output - bla, bla bl, bla bla, bl)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source