[Werner]

select * from information_schema.columns where column_name like '%\$0'%
you must protect the dollar sign \$ as it is used as a placeholder.
select * from information_schema.columns where column_name like '%${1:variable}'%