$result = mysql_query("SELECT * FROM sayfalar WHERE (lower(url) like '%$search%' OR lower(etiketler) like '%$search%' OR lower(title) LIKE '%$search%' OR lower(aciklama) like '%$search%') AND onay='1'");

deneyin.