create table lyr_lyrics (
	id int unsigned not null auto_increment primary key,
	artist varchar(255) not null,
	title varchar(255) not null,
	text text not null,
	fulltext (artist, title, text)
);

insert into lyr_lyrics (artist,title,text) values (...);

select id,artist,title,match(artist,title,text) against ('...') as score
	from lyr_lyrics where match(artist,title,text) against ('...');
