Re: [sqlite] LIKE operator with prepared statements

[Dennis Cote]

Marian Olteanu wrote:

But why don't you use
SELECT x from y WHERE y.x LIKE ? ;

and bind the first parameter to "%SomeText%" instead of "SomeText" like
before?


Chad,

You could also do this: 

SELECT x from y WHERE y.x LIKE '%' || ? || '%' ;

The || operator concatenates the % characters with your string.  Now you 
don't need to massage the string in the calling code.  Six of one, half 
dozen of the other.

HTH
Dennis Cote