match against in mysql

CREATE TABLE articles (

id int(11) NOT NULL DEFAULT ‘0’,

title varchar(65) DEFAULT NULL,

topic varchar(25) NOT NULL DEFAULT ‘’,

author varchar(25) NOT NULL DEFAULT ‘’,

ondate datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,

body text NOT NULL,

KEY index_id (id),

FULLTEXT KEY title (title,body)

) ENGINE=MyISAM DEFAULT CHARSET=utf8$$

select id,title FROM articles WHERE

MATCH(title) AGAINST (‘+cvs’ IN BOOLEAN MODE) limit 1000;

what you have to consier is depending on DB Engine

Comments