you have to use
select * from contacts where contacts LIKE '%t-online.de%'
Il 23/11/2010 14.53, ady ha scritto:
> Hello!
>
> I am trying this query
>
> select * from contacts where contacts match ('*t-online.de*')
>
> How could i modify this query to return say [email protected] ?
>
> the - is an exclusion
>
> Thanks in advance!
>
> Ady
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
Selea s.r.l.
Michele Pradella R&D
SELEA s.r.l.
Via Aldo Moro 69
Italy - 46019 Cicognara (MN)
Tel +39 0375 889091
Fax +39 0375 889080
*[email protected]* <mailto:[email protected]>
*http://www.selea.com*
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
