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 Fulltext's parameters configurable - easier to configure, that would be nice/customizable. > The first problem is, extracting multiple keys from text, for matching > against keys in another table, is usually the sort of thing that is best > done before the data comes into the database. Oh, I did that for 5 of the 15 possibles items. It took days of Perl regex and hand editing. The source was a fossilized flat-file from the 1970's. Since I could not tease-out all the data into db fields I made a separate table w/the PK and the raw data as fields and a table with PK and 4 of the clean fields I could "regex out". The "raw" data's in a TEXT filed. Not quite the natural language for fulltext but it's not discrete fields either... > The reason is that the > assumptions underpinning SQL are not compatible with your use of the text > column as a key bank: your use violates one of Codd's rules, that a > single> column should yield only one value. See above - I wouldn't violate Dr. Codd's rules without a fight. Thanks for the help....snip... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
