On Wed, 14 Jul 2004 11:17:20 -0500, "Peter Brawley"
<[EMAIL PROTECTED]> said:
> Match() returns a graded "relevance rating", snip...
> you are looking for, though what you're looking for isn't entirely clear
> from your post.
It'll do OK. I would like to suggest if there's a wish list to make
Fax to:
07/14/2004 10:06 Subject: Search one table
Does access_no contain actual textual data, or is it
simply a key like a category or an integer? If you
don't need to do a fulltext search against access_no
then there is no reason to include it in your fulltext
index. You should most likely have a seperate index
for access_no in that case.
The
sion logic to find the matches you want, so have a look
at in the manual.
Once you reslve these two problems, probably simple JOIN syntax will get you
the SQL result you need.
HTH.
PB
- Original Message -
From: leegold
To: mySQL mailinglist
Sent: Wednesday, July 14, 2004 9:06 AM
If you would entertain a MYSQL/PHP, hope not too off-topicIt's
probably not difficult to solve - but you would be helping me
with some SQL logic.
The only way I can think of to explain what I want to do
is to give you my working newbie MSQL/PHP code that I'm learning
MYSQL/PHP with, and at a cert
