Using LIKE with RAWQUERY

[eduo]

Hi, there.

Been a happy user for many years but today I had the need to do a rawquery that requires like with wildcards and I just couldn't make it work.

For various reasons I need to use rawquery for this specific query, but the string to search by must match only the end of the field, so normally I'd use LIKE '%endstring'.

In Rawquery parameters are encoded by using a question mark and then an array of values replacing the question marks in order.

But doing it this way breaks here. LIKE %? will end up sent as LIKE %'endstring' and LIKE '%?' will end up completely break.

I could do something ugly like LIKE '%".$endstring."'" but this kind of defeats the purpose.

[palsypentertainment]

If you want to escape a var, can't you do something like

$endstring = $this->db->escape( $enstring );

Then you can do LIKE '%".$endstring."'"