fulltext like index for data?

[Sandro Sigala]

Hello, I have created a table containing the following fields:

CREATE TABLE  msgs (
       rec_id int(11) NOT NULL AUTO_INCREMENT,
      message_id varchar(80) NOT NULL DEFAULT '',
);
The items (millions) are like the following:

'1', '[EMAIL PROTECTED]'
'2', '[EMAIL PROTECTED]'
'3', [EMAIL PROTECTED]'
... etc.
The message_id is a quasi-random text string.

I need to execute queries matching substrings like the following:

SELECT * FROM msgs WHERE message_id LIKE '%substring%';

Of course queries like this are very slow because executed on every row 
of the
table. I would like to index the 'message_id' column, but the elements 
are not
natual language words that can be indexed with FULLTEXT.

What is a good solution for this?

Thanks in advance,
 Sandro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]