SQL:SELECT *, ((CASE WHEN cloud LIKE '%%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Athens%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Athens%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Northern%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%suburbs%' THEN 1 ELSE 0 END)) AS relevance FROM properties WHERE (cloud LIKE '%%') AND (cloud LIKE '%Athens%') AND (cloud LIKE '%Athens%') AND (cloud LIKE '%Northern%') AND (cloud LIKE '%suburbs%') ORDER BY pid DESC
Loading your selected locations...