[ArthurZ]

Hello, consider the following snippet created
select * from information_schema.columns where column_name like '%$0'%
I submit the input on tab and it is not places where expected
select * from information_schema.columns where column_name like '%%test'

[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}'%

[ArthurZ]

Hi Werner, thanks but
It doesn’t work as advertised:
In the former case I get '%$0'% so the $0 has not been even actioned (remains in there not to be substituted), and
In the latter case you get
like '%variable'% note the quote before the % sign.

[Yutaka Emura]

I am not sure if I understand your question. Can you please simplify your question, and include your expected result? Please write a step-by-step procedure to reproduce the issue. Thank you.

[Author]

Posts