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 DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
