SQL - 搜索表中的所有列

Question

  $whereClauses = array(); 
  if (! empty($_POST['house'])) $whereClauses[] ="type='".mysqli_real_escape_string($conn,$_POST['house'])."'"; 
  if (! empty($_POST['price'])) $whereClauses[] ="rate ".mysqli_real_escape_string($conn,$_POST['price']).""; 
  if (! empty($_POST['any'])) $whereClauses[] ="title or area or postcode LIKE '%".mysqli_real_escape_string($conn,$_POST['any'])."%'"; 
  $where = ''; 
  if (count($whereClauses) > 0) { $where = ' WHERE '.implode(' AND ',$whereClauses); }

I can't seem to get the like statement to work e.g. it wont display any results that match the title column if there is one for the area column, i want all the matches to show. Also whenever i use the 3rd if statement it ignores the first two such as i only want houses that cost over £1000 it will display the ones below that when i use the like.

sql where: WHERE type='House' AND rate > 150 AND title OR area or postcode LIKE '%s%'

</div>