En iyi sonuç

SELECT * FROM people WHERE MATCH (name,lastname,about) AGAINST ('Recep Tayyip Erdoğan') ORDER BY name,lastname ASC;

SELECT * FROM people WHERE lastname LIKE '%Erdoğan%' || name LIKE '%Recep Tayyip%' ORDER BY name, lastname ASC

$query = "SELECT name,lastname,about,picture FROM people WHERE name LIKE '%$adi%' || lastname LIKE '%".$bol[($kac-1)]."%' ORDER BY name, lastname ASC";

SELECT name,lastname,about,picture FROM people WHERE name LIKE '%Mehmet%' AND lastname LIKE '' ORDER BY name, lastname ASC

$qtag=mysql_query("Select * from tags order by tarih DESC limit 0,10");
   while ($rtag= mysql_fetch_array($qtag)) {
$varam = $rtag['tag'];   
$varam = dur($varam);
$q=mysql_query("SELECT *, MATCH(adi, acik) AGAINST('$varam') AS score FROM table WHERE kilit=0 and MATCH(adi, acik) AGAINST('$varam') 
            ORDER BY score DESC LIMIT 0,2") or die(mysql_error());
   while ($r= mysql_fetch_array($q)) {
}