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 

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 Swan
Web Programming Specialist
Carroll College CCIT

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

Reply via email to