drop table if exists diaries;
set names utf8;
create table diaries (
id int primary key,
title varchar(255),
content text,
fulltext index (title, content),
fulltext index (title),
fulltext index (content)
) default charset utf8 COMMENT = 'engine "innodb"';
show create table diaries;
Table	Create Table
diaries	CREATE TABLE `diaries` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`,`content`),
  FULLTEXT KEY `title_2` (`title`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='engine "innodb"'
insert into diaries values(1, "Hello", "はじめました。");
insert into diaries values(2, "天気", "明日の富士山の天気について");
insert into diaries values(3, "富士山", "今日もきれい。");
delete from diaries where id = 2;
select * from diaries where match(title, content) against("富士山");
id	title	content
3	富士山	今日もきれい。
select * from diaries where match(title) against("富士山");
id	title	content
3	富士山	今日もきれい。
select * from diaries where match(content) against("富士山");
id	title	content
drop table diaries;
