Hello, As you all know InnoDB doesn't support full text search. My application is a huge news system with about 100 new news per day. All of my tables are in InnoDB becouse of foreign keys. Today I find out that the main feature of news system - searching - is not available. It's quite big problem... Do you have any ideas how to search text tables in InnoDB ?? Of course I know about querys using LIKE = '%%' but it isn't so effective and good as FULL TEXT... Maybe in further versions (4.1) of MySQL, InnoDB will support this feature ??
Thanks for answer. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php