Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #27837
    ArthurZ
    Participant

    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'

    #27840
    Werner
    Participant

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

    #27842
    ArthurZ
    Participant

    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.

    #27873
    Yutaka Emura
    Keymaster

    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.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.