1

I have been searching for Oracle functions that are equivalent to to MySql Match Against.

Any help will be greatly appreciated

user964147
  • 729
  • 4
  • 10
  • 29
  • 2
    They don't exist. There's `LIKE`, regexes, and more of those features (which MySQL supports as well), but the FULLTEXT index of MySQL (MyISAM to be more precise) doesn't exist in Oracle, and that is what is used for `MATCH AGAINST`. – GolezTrol Sep 24 '12 at 19:39

1 Answers1

1

As a WHERE condition this does not exist but the main advantage when you use MATCH AGAINST is that you use a FULLTEXT index and that exits in Oracle also and is called Oracle Text. See the following answer: Does Oracle support full text search? or make a general search for "Oracle Text".

Community
  • 1
  • 1
hol
  • 8,255
  • 5
  • 33
  • 59