Searchengine Fault

[Anon]

I have build a small searchengine based on a mySQL database:

this is the searchstring:
<?PHP
require ("conf.php");
$server = mysql_connect($host,$user,$pass);
mysql_select_db($db,$server);
$query = "SELECT * FROM mp3
WHERE info LIKE '%songquery%' GROUP BY artist";
?>

In stead of searching through the column info, I want the string to search through the columns Artist and Song simultaniously.
Is this possible and if yes how??

thank you

[spxdcz]

Have a look at the mysql documentation (on www.mysql.com), specifically at 'full text' indexes and the 'match against' clause - you'll find your results are much more relevant than a simple 'like' query, and the documentation includes examples for matching multiple columns.

[Anon]

Thx, will check it out