mysql - 如何缩小 MySQL 全文搜索结果的范围？

Question

我有一个 MySQL 全文搜索引擎，我想允许用户通过为结果添加年份范围来过滤结果。我有一个名为 year 的列，其中的年份从 1999 年到 2011 年不等。如何更改我的 mysql_query 以反射(reflect)这一点？变量 $fyear 是用户希望开始的年份(低端)，$tyear 是结束的年份(高端)。

<?php
mysql_connect("localhost", "root", "root");
mysql_select_db("database");

$var = @$_GET['q'];
$fyear = @$_GET['from_year'];
$tyear = @$_GET['to_year'];

if (isset($var)) {
$sql = mysql_query("SELECT *, MATCH(subj_name, course_name) AGAINST ('$var') 
AS score from table1 WHERE MATCH (subj_name, course_name) AGAINST('$var') 
ORDER BY score desc");
}

注意:year 列是一个整型字段

Answer 1

看看运算符between .

$sql = mysql_query("SELECT *, MATCH(subj_name, course_name) AGAINST ('$var') AS 
score from table1 WHERE year BETWEEN '$fyear' AND '$tyear' MATCH (subj_name, course_name) AGAINST('$var') ORDER
BY score desc");