MySQL Forums
Forum List  »  Full-Text Search

Full-text queries
Posted by: Aimee Ault
Date: January 02, 2005 11:42PM

I set up a table in my database using this query:

CREATE TABLE user_driver2(driver_name VARCHAR(64),
driver_first_name VARCHAR(32),
FULLTEXT(driver_name),
FULLTEXT(driver_first_name))
TYPE=MyISAM;

This seems to work fine.

After doing this, I use this query:

INSERT INTO user_driver2 VALUES
('Aimee Ault', 'Aimee')
('Chris Jobs', 'Chris')
('Aimee Mann', 'Aimee')
('Chris Johnson', 'Chris');

This successfully puts in those 4 records.

But then I do this:

SELECT * FROM user_driver2 WHERE MATCH(driver_name) AGAINST('Aimee')

And it returns 0 records. What gives? If I put in 'Ault' or any last name, it works fine, but if there is more than one instance of something, it won't return any records. Can anyone tell me what I'm doing wrong?

Thanks in advance,
Aimee

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-text queries
3783
January 02, 2005 11:42PM
2657
January 03, 2005 12:08AM
2659
January 14, 2005 05:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.