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 m...@t-online.de ?
>
> the - is an exclusion
>
> Thanks in advance!
>
> Ady
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> 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
*michele.prade...@selea.com* <mailto:michele.prade...@selea.com>
*http://www.selea.com*
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
