Re^2: DBI mysql substring_index syntax error

But, there are no variables in this query :) I agree with you, I always use placeholders.

Comment on Re^2: DBI mysql substring_index syntax error

Replies are listed 'Best First'.
Re^3: DBI mysql substring_index syntax error by Laurent_R (Canon) on Oct 22, 2014 at 06:57 UTC
Yes, which means that you don't need interpolation and that you could use a differfent quoting mechanism. I can't test it, but using `q` instead of `qq` with your original string should probably be sufficient. Or you could possibly use the `quotemeta` function to get the escaping right.	[reply] [d/l] [select]