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 25 rows.
Hi there,
I have a big table which has 25 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 s
Hi there,
I have a big table which has 25 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 sp
