Check out full-text indexing:
http://www.mysql.com/doc/en/Fulltext_Search.html
I don't think there's any other way to improve searching in
unstructured text using MySQL
-steve
At 3:58 PM -0700 8/27/02, Sanny Sun wrote:
>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.
>
--
+------------------------------------------------------------------------+
| Steve Edberg [EMAIL PROTECTED] |
| University of California, Davis (530)754-9127 |
| Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ |
+------------------------------------------------------------------------+
| The end to politics as usual: |
| The Monster Raving Loony Party (http://www.omrlp.com/) |
+------------------------------------------------------------------------+
---------------------------------------------------------------------
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
