Tagged: 

Viewing 3 posts - 1 through 3 (of 3 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.

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