Jump to content


Photo

Mysql FULLTEXT search


  • Please log in to reply
1 reply to this topic

Poll: I need help with full text search (0 member(s) have cast votes)

I need help with full text search

  1. Can help (0 votes [0.00%])

    Percentage of vote: 0.00%

  2. wont help (0 votes [0.00%])

    Percentage of vote: 0.00%

Vote Guests cannot vote

#1 samuelba

samuelba
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 11 October 2006 - 02:55 PM

CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body)
)
ENGINE=MyISAM;
//

INSERT INTO articles (title,body) VALUES
('MySQL Tutorial','DBMS stands for DataBase ...'),
('How To Use MySQL Well','After you went through a ...'),
('Optimizing MySQL','In this tutorial we will show ...'),
('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
('MySQL vs. YourSQL','In the following database comparison ...'),
('MySQL Security','When configured properly, MySQL ...');


SELECT id, body, MATCH (title,body) AGAINST
('Security implications of running MySQL as root'
IN NATURAL LANGUAGE MODE) AS score
FROM articles WHERE MATCH (title,body) AGAINST
('Security implications of running MySQL as root'
IN NATURAL LANGUAGE MODE);

This is a direct exert from MYSQL pages and the select section does not work... I have no idea why.. can someone please help.. is it a seetings issue as I assume coming from their site it should work?

http://dev.mysql.com...ext-search.html

Sam

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 11 October 2006 - 07:58 PM

Doesn't work how?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users