MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.6.51


CREATE TABLE `tl_news4ward_article` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`keywords` text,
`description` text,
PRIMARY KEY (`id`),
FULLTEXT KEY(keywords,title,description)

) ENGINE=MyIsam AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;
INSERT INTO tl_news4ward_article VALUES (1, 'something', 'something', 'something');
CREATE TABLE `tl_news4ward_tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
  `tag` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyIsam AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;
CREATE
OR REPLACE VIEW `tl_news4ward_articleWithTags` AS
SELECT
  tl_news4ward_article.*,
  GROUP_CONCAT(tag) AS tags
FROM
  tl_news4ward_article
  LEFT OUTER JOIN tl_news4ward_tag ON (
    tl_news4ward_tag.pid = tl_news4ward_article.id
  )
GROUP BY
  tl_news4ward_article.id;
SHOW INDEXES FROM `tl_news4ward_articleWithTags`;
  SELECT MATCH (keywords,title,description) AGAINST (' something1 something2' IN BOOLEAN MODE) AS score FROM tl_news4ward_articleWithTags;


score


0