Re: Keyword Search

2004-08-12 Thread Robert Reed
It would probably be better to post this to the Lasso discussion list at Blueworld.com as for Lasso, this will require you to use tags but it's been ages since I coded with Lasso (3.6 and FileMaker. :) and I can't recall/never knew, the tag modifications. Good luck --- maggie chloe <[EMAIL PROTE

Keyword Search

2004-08-11 Thread maggie chloe
I am new to Lasso and My SQL, but I have a pretty basic question on searching a text field using Keywords. I think I am missing something easy. I have a MySql database and am using Lasso 7. The user enters search information on a form on a search.lasso page and an inline search is then ru

Re: Problems with boolean keyword search

2004-06-17 Thread Andreas Ahlenstorf
Hello, Eamon Daly schrieb am Donnerstag, 17. Juni 2004 um 19:04: > FYI, MySQL allows boolean searching as of 4.0.1. See: > http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html I normally use that. But: Very bad result quality because there are only sigle keywords. I tried it with a text colum

Re: Problems with boolean keyword search

2004-06-17 Thread Eamon Daly
: "Andreas Ahlenstorf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 11:40 AM Subject: Problems with boolean keyword search > Hello, > > I have to build a keyword search with support for the boolean > operators +, -, * and ". > >

Problems with boolean keyword search

2004-06-17 Thread Andreas Ahlenstorf
Hello, I have to build a keyword search with support for the boolean operators +, -, * and ". Basically it's quite easy: Connect the three tables with two joins, keyword search with LIKE. But the boolean operators give me a headache. mysql> SELECT c.id FROM keywords A

RE: Dumb Newbie Keyword Search Question

2002-03-25 Thread Paul DuBois
ww.mysql.com/doc/F/u/Fulltext_Fine-tuning.html > > > > >-Original Message- >From: Dan Tappin [mailto:[EMAIL PROTECTED]] >Sent: Monday, March 25, 2002 10:03 AM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Re: Dumb Newbie Keyword Search Question > >

RE: Dumb Newbie Keyword Search Question

2002-03-25 Thread Tal-ee
, 2002 10:03 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Dumb Newbie Keyword Search Question Thanks Alec, That is exactly what I was looking for. Dan > I think what you want is a FULLTEXT index with the MATCH operator - see > http://www.mysql.com/doc/F/u/Fulltext_Searc

Re: Dumb Newbie Keyword Search Question

2002-03-25 Thread Dan Tappin
Thanks Alec, That is exactly what I was looking for. Dan > I think what you want is a FULLTEXT index with the MATCH operator - see > http://www.mysql.com/doc/F/u/Fulltext_Search.html . > > Particularl.y, see the new developments in fulltext in V4.0.1 half way doen > the page > >Alec Cawle

Dumb Newbie Keyword Search Question

2002-03-24 Thread Dan Tappin
I have been looking through the mailing list archives but I can seem to find a straight forward answer anywhere. I have a MySQL table with a variety of text columns I would like to search. Pretty basic... A web search form returning the users input $keywords. Some type of relevance system would

Keyword search string

2001-03-03 Thread MikeBlezien
Greetings, I have a table that has a column where search keywords are entered. column searchwords word1 word2 word3 ..etc Now when this column is queried for a search, I'm wonder how is the best way to evaluate matching the keywords. In the SELECT query, would I get better results if I use: