Q:

Mysql - using numbers in Match Against

I want to convert this mysql code using the match against clause
Select * from table_1 Where age >= 2 && age <= 10

What would be the equivalent for this in match against?

A:

MYSQL table engine must be MyISAM and doesn't support  less than < or > greater than for "MATCH AGAINST" see this link for more info.
search_modifier:
  {
       IN NATURAL LANGUAGE MODE
     | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION
     | IN BOOLEAN MODE
     | WITH QUERY EXPANSION
  }

