MySQL fulltext search with InnoDB table?

From: Date: Tue, 03 Aug 2004 19:44:52 +0000
Subject: MySQL fulltext search with InnoDB table?
Groups: php.db 
Request: Send a blank email to php-db+get-35562@lists.php.net to get a copy of this message
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

« previous php.db (#35562) next »