sql injection protection . using LIKE instead of =

Hi,

How do I ensure that there is SQL inejection protection when using the LIKE.
example

select a,b,c from table where (a=%1%) , $a  - is in the example
how do I rewrite if the query is something like
select a,b,c from table where a like 'a%' - to search for something starting with a .

an example like this is not working:

$query = "select a,b,c  from table where (a=%1%) and (b like '%2%') , $a, '$b%'";
$result = $a1db->GetRows($query);

Thanks,
Shashi

Hi,

I guess your question is about TbsSQL.

Something like this should work:

or: