Table is like:
ID Text_Column 1 "Jason" 2 Jason Harvey 3 "Ramsy"
I wrote dynamic variable query like
SELECT bla bla FROM bla_table WHERE col1 IN ('"""+dynamic_var_here+"""', 'CONCAT('"',"""+dynamic_var_here""",'"')')
Due to another code section being dependent on the rows of my table I have removed the double quotes from the values which is being passed to the dynamic varibale here.
So, basically I need that the "IN" part checks both the values i.e. Jason and "Jason", whichever is present and thus accordingly makes decision.
However, I get an empty result for above code. I think there is some problem with the CONCAT section the way I have written it but not sure where.