Multiple columns question

[Doug Dalton]

How do I do the query :

Select * FROM database WHERE FirstName LIKE '%$FirstName%' AND LastName LIKE '%$LastName%' AND Job LIKE '%$Job%'

If I do
Select * FROM database WHERE MATCH (FirstName,LastName,Job) AGAINST ('$FirstName $LastName $Job')

This matches all the fields against all the search options not matching specific fields to specific columns, but my understand ins that you cannot do

Select * FROM database WHERE MATCH (FirstName) AGAINST ('$FirstName') AND MATCH (LastName) AGAINST ('$LastName') AND MATCH (Job) AGAINST ('$Job')

so how can I do this last search with the Fulltext option?