What is the equivalent of using column_name like %{{param_name}}%?

Column_name = {{param-name}} works in SQL Runner but column_name like %{{param-name}}% will not work. Equivalent of using column_name like %{{param-name}}% is column_name like ‘%{{#raw param-name}}%’