Le ven 16/01/2004 à 15:30, George Ionescu a écrit : > I've been using sqlite for quite some time now and I am a fan (thank you Dr. > Hipp).
so am I > Regarding Full Text Search syntax, I think CONTAINS statement would be ok > (as implemented in other database engines). > So: > SELECT * FROM Categories > WHERE CONTAINS(CategoryDescription, 'Beverages') > would return all the rows where column CategoryDescription contains the > word 'Beverages' :-) doesn't SELECT * FROM Categories WHERE CategoryDescription LIKE '%Beverages%'; do just that ? I guess full-text indexing applies to columns containing larger chunks of text... D.Morel -- *********************************************** [EMAIL PROTECTED] OpenPGP public key: http://www.amakuru.net/dmorel.asc 28192ef126bc871757cb7d97f4a44536
signature.asc
Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e=2E?=
