Nevermind, I'm wrong.
--- Marco Radaelli <[EMAIL PROTECTED]> ha scritto:
> 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]
>
-----------------------------------------------------------------------------
>
>
__________________________________________________
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]
-----------------------------------------------------------------------------
