mysqlmatch-against

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?

Solution

  • 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
  }