USE test;
DROP TABLE IF EXISTS news;
CREATE TABLE news (
  id mediumint(8) unsigned NOT NULL auto_increment,
  author_id smallint(5) unsigned NOT NULL default '0',
  startdate date NOT NULL default '0000-00-00',
  title varchar(255) NOT NULL default '',
  article text,
  url varchar(255) default NULL,
  active tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id,title),
  UNIQUE KEY id (id),
  KEY id_2 (id),
  FULLTEXT (title, article)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

select * from news where match(title, article) against ('wettbewerb')