SELECT *, MATCH(header, spot, description, tags) AGAINST('search_tag') AS search
FROM games
WHERE MATCH(header, spot, description, tags) AGAINST('search_tag')
ORDER BY search DESC;
fulltext index eklemelisin. İnternette araştırırsan SQL MATCH kriteriyle kesinlikle bulunur.