Thanks for that. Its just that i am developing an application using
PHP/Sqlite and was having a major problem with escaping. But i got it
eventually. for anyone who might have a problem its.
<?
.....
$SQL = "Select *
From people
where name LIKE '".$_GET['criteria']."'
Order by Name ASC ";
......
?>
On Thu, 2006-04-13 at 07:57 -0400, Igor Tandetnik wrote:
> Roger <roger-FNkchr/[EMAIL PROTECTED]> wrote:
> > hwo do i use LIKE in sqlite
> >
> > eg in
> >
> > Select Surname
> > from people
> > where surname like A* etc.
>
> where surname like 'A%'
>
> Igor Tandetnik
