MySQL fulltext search with InnoDB table?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What is the best way to simulate a fulltext search on a MySQL table of type InnoDB?  Do I index the searchable fields and use the LIKE() function with appropriate wildcards?

What are the performance implications with this?  Switching back to a table type of MyISAM is really not an option.  Is there an "accepted" way of dealing with this issue?

Thanks in advance for any tips,


Nicole
---------------------------
Nicole Swan
Web Programming Specialist
Carroll College CCIT
(406)447-4310

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux