Просмотр поста

Оо такой поиск

$result = mysql_query('SELECT `answer` FROM `bot` WHERE `keys`="' . $str . '" ORDER BY RAND() LIMIT 1');
 if (!mysql_num_rows($result)) {
$result = mysql_query('SELECT `answer` FROM `bot` WHERE MATCH (`keys`) AGAINST ("' . $str . '" IN NATURAL LANGUAGE MODE) > 0 ' . ' ORDER BY RAND() LIMIT 1');
 }
 if (!mysql_num_rows($result)) {
$result = mysql_query("SELECT *, MATCH (`keys`) AGAINST ('" . $str . "') as `rel` FROM `bot` WHERE MATCH (`keys`) AGAINST ('" . $str . "') > 0 ORDER BY `rel` DESC LIMIT 1;");

 }