Hello,
I am running 4.0.15 for Win95/98 and am working through the docs.
I created a "text" type field with a 'fulltext' index. As I am experimenting, I
have run into a couple of questions:
First off, I was having trouble getting results. So I added the word "foobar"
to one of the descriptions:
and that worked with this query:
select * from item where match(name, description) against('foobar')
I have a word 'red' that appears 5-10 times, in a tmp table of 60 records.
If I run that query with 'red'
select * from item where match(name, description) against('red');
it returns empty set
Upon reading, it looks like it is really trying to only get "unique" names from
the index. But in my case the 'red' is a description that I would like to get
back. Anyway to force this to return results?
Any info would be helpful. I have read, but it gets a little confusing first
time through.
Thanks,
Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
