Re: INDEXes on BLOB Columns

At 5:29 -0400 9/10/03, Andrew Kuebler wrote: If I: ADD COLUMN Text (BLOB) And then INDEX (Text(10)) Will that index be beneficial if I am search for 10 characters only or anything 10 characters or less? Thanks in advance! If those characters occur at the beginning of column values, yes. -- Paul D

INDEXes on BLOB Columns

If I: ADD COLUMN Text (BLOB) And then INDEX (Text(10)) Will that index be beneficial if I am search for 10 characters only or anything 10 characters or less? Thanks in advance! Best Regards, Andrew Sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u