ANSWERS: 2
  • Unfortunately right now your only option is to create your own version of the full text index. There are open source full text engines available. Here's 1: http://www.swish-e.org/ You can also write your own, if you're so inclined. Edit: There's also the spynx project, which provides full text search. http://www.sphinxsearch.com/ Another approach is to copy your data into a MyISAM table and do your full text search queries on that.
  • I'm not familiar with InnoDB but if it doesn't support full text search you can still break it up into a dynamic SQL query using ANDs and ORs.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy