mysql query help

dear friends i am new php learner
i have a search script which fetch data
only by single keyword "online"
i want to make multiple keyword search like

"online real estate"
"real estate online"
"real online estate"

here is my code Kindly help

$sp = trim($_POST['art']);
$sp = preg_replace('/\s+/','',$sp);

if($sp == ''){
echo 'keyword required';
}
else
{
$con = mysql_connect("xxxxxxxx","xxxxxxx","xxxxxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("engine", $con);

$result = mysql_query("SELECT * FROM tablename WHERE name LIKE '%$sp%' OR phone LIKE '%$sp%' OR keyword LIKE '%$sp%' OR city LIKE '%$sp%'");

while($row = mysql_fetch_array($result))
{
echo $row['name'] . " " . $row['phone'];
echo "<br />";
}
}
?>

 

Use MySQL's FULLTEXT search capability.