I didn't know the "CREATE COLLECTION" syntax
and didn't find it in the latest mysql manual, does it use
an index similar to udmsearch ?
I think I have seen something in the udmsearch
sources to index a database.
Here is what I would do if it's not what it does
already.
If your table is : table t ( id int , s text ) :
If you use php on your site (similar for perl or cgi I guess) :
basedoc.php :
for each ($id in t)
echo something hyperlinked to doc.php?id=$id
doc.php :
display (select s from t where id=$id)
then launch udmsearch on basedoc.php
when you search a text and it returns doc.php?$id it means
that your searched matched the doc witht the identifier $id.
Alain
---- Message d'origine -----
De : Rasmus Lerdorf <[EMAIL PROTECTED]>
À : Adam Thyer <[EMAIL PROTECTED]>
Cc : <[EMAIL PROTECTED]>
Envoyé : mercredi 5 juillet 2000 19:27
Objet : Re: UdmSearch: Searching a MySQL database?
> MySQL 3.23.20 and later has built-in text searching. Use it like this:
>
> CREATE COLLECTION collectionname ON tbl_name (col_name[(length)],...)
> SELECT * from table WHERE MATCH (col1, col2) AGAINST "sentence"
>
> This will return all rows from table where col1 or col2 contains
> the word sentence.
>
> -Rasmus
>
> On Thu, 6 Jul 2000, Adam Thyer wrote:
>
> > Hi All
> >
> > Could UdmSearch be used to search a MySQL database containing Web site
> > reviews, or can it only index static pages?
> >
> > Thanks
> >
> >
> > Adam
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]