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
