I want to prepare a statement like this one: SELECT name FROM people WHERE name LIKE '%?%'But, it looks like host parameters inside string literals aren't parsed. Any clues as to how I pull this off or if the parameter really will be parsed?
SELECT name from people WHERE name LIKE ? Your parameter then should contain the text to look for, such as "%mytext%"