UPDATE: Would this be any

DarkLight — Thu, 09 Feb 2012 02:05:05 +0000

UPDATE: Would this be any better? I decided to go the FullText route and implemented that instead... Works great, but is it better on millions of rows?

<?php
$result = mysql_query("SELECT *, MATCH(SongName,ArtistName,AlbumName) AGAINST('$terms') AS score FROM songs WHERE MATCH(SongName, ArtistName, AlbumName) AGAINST('$terms') ORDER BY score DESC LIMIT 30");
?>