how do i search multiply fields for a keyword

[mmoalem]

hi there - probably simple but cant find a straight example of this anywhere and i am very newby when it comes to programming.

have a php search file that works fine with my mysql database. it use this argument for searching:

$result = mysql_query("SELECT * FROM ppl_tracks WHERE Keywords LIKE '%$_POST[searchkeywords]%' AND Mixed !=false ORDER BY Track");

obviously Keywords is the field searched but i want it to look for 'searchkeywords' in another field - 'Description'

 

and while at it - is it possible to enter 2 or more keywords in the submit form (using $POST) that will be searched in the 2 fields and will return a list ordered by relevancy (how many of the keywords searched appear in each record)

 

hope this makes sense to someone