This is my query:
$result=mysql_query("select id, file, city from multimedia
where match(search) against('$query' in boolean mode) limit $start,$step") or die('Error');
I have created a fulltext index on column "search".
Good so far, but I need to add additional condition to the query:
$result=mysql_query("select id, file, city from multimedia
where match(search) against('$query' in boolean mode) and city='$city' limit $start,$step") or die('Error');
I can not add "city" column to the "search" index. City column is "mediumint(5)" but Php MyAdmin allows to add only varchar columns to the fulltext index.
Does it mean that fulltext indexes can't contain "int" columns?
Any ideas? Thanks.
