Try
SELECT * FROM mytable where 'c:\\Program Files\\a.exe'
like '%command%'
--- Florin Serbanescu <[EMAIL PROTECTED]> ha scritto:
> Hello,
>
> I have a string that contains a full path of a file
> for example. Also I have a table in Sqlite that
> contains a column name 'command' that has only the
> filename. My question is how I can create a query so
> I
> can retrieve all rows where command field is a
> substring of my string. In MySQL for example I can
> do
> this:
>
> SELECT * FROM mytable where 'c:\\Program
> Files\\a.exe'
> like concat('%',command,'%').
>
> But it seems that in Sqlite does not work. Would be
> something like:
>
> SELECT * FROM mytable where 'c:\\Program
> Files\\a.exe'
> like '%'||command||'%'.
>
> In other words I need to search in a table a
> substring
> of my string. So is quite vice versa of the normal
> string search with like.
>
> Thank you for your help,
>
> Florin.
>
>
>
>
____________________________________________________________________________________
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail
> beta.
> http://new.mail.yahoo.com
>
>
-----------------------------------------------------------------------------
> To unsubscribe, send email to
> [EMAIL PROTECTED]
>
-----------------------------------------------------------------------------
>
>
__________________________________________________
Do You Yahoo!?
Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo spam e ti da tanto
spazio gratuito per i tuoi file e i messaggi
http://mail.yahoo.it
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
