Insert regex pattern into db table

I want to insert regex pattern into the table as a value. For eg : INSERT INTO table VALUES("r|h[at]"). So when I execute SELECT * from table where name == "hat"; I'll get 1 row. How can I insert regex pattern into a column as value?