Hi there, I have a big table which has 250000 rows.And each row has a BLOB field which stores lots of text. When I search text in this table(using the query: where CONTENT like '%news%'),the searching speed is quite slow. is there anybody also have such problem? Any ideas about improving the speed of searching text in big table?
Thanks in advance. Sanny --------------------------------------------------------------------- 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
