SELECT count(*) FROM sites
WHERE MATCH(title, url, stripped) AGAINST('test' IN BOOLEAN MODE) AND stat = 'A'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sites	fulltext	match_url_title_stripped	match_url_title_stripped	0		1	Using where