Query:

codice:
ALTER TABLE decks ADD FULLTEXT(`cards`); 

SELECT COUNT(1) as tot_decks, d.format, d.type, d.id, d.image, d.tot_cost, d.views, d.likes, d.hero, d.name, d.date, u.nickname, d.author FROM decks AS d
		INNER JOIN users AS u ON (d.author = u.id)
		WHERE  MATCH(d.cards) AGAINST('+Claw' IN BOOLEAN MODE)  AND  d.saved = 0
		GROUP BY d.id
		ORDER BY d.likes, d.date DESC
		LIMIT 12
Ovviamente nella colonna cards abbiamo la stringa "Claw"