Keyword search

sql.php

<?php
    $search_query = "cattle rearing"; // example
    $search_words = explode(" ", $search_query);
    $sql = "SELECT * FROM _index WHERE ";
    for ($i = 0; $i < count($search_words); $i++) {
        $sql .= "CONTAINS(keywords, '{$search_words[$i]}')";
        if ($i < count($search_words) - 1) $sql .= " AND ";
    }
    echo "SQL Query: " . $sql;