Darren Duncan <[EMAIL PROTECTED]> wrote:
>
> Alternately, and probably more elegantly,
>
>SELECT name FROM people WHERE name LIKE '%' || ? || '%'
>
Yes, it is mome elegant. Unfortunately, SQLite is stupid and
does not optimize this well. It computes the concatenation once
per row instead
At 10:10 AM -0700 1/18/06, Robert Simpson wrote:
- Original Message - From: "Marvin K. Bellamy"
<[EMAIL PROTECTED]>
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
- Original Message -
From: "Marvin K. Bellamy" <[EMAIL PROTECTED]>
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 paramete
3 matches
Mail list logo
