in reply to Re^2: SQL LIKE and Binding Variables
in thread SQL LIKE and Binding Variables
For postgres, the string concatenator would have to be '||' instead of '+'.
(A quick test seems to indicate SQLite wants '||' as well, which makes sense as that is the standard SQL concatenator)
see (maybe) also: dbi, placeholder and postgres regular expression problem
hth
|
|---|