Index and Fulltext index on MySQL

[tasistro]

OK I have a table with a event ID and a user's name on two separate columns. I'm doing full text search on the user's name. The user's name field is varchar and the event ID is numeric. Is there a way to create an Index that includes both the numeric and text fields in such a way I can do a full text search on the name. I've been looking around and found none. Only idea I have is to make the event ID text and do a full text search on both. The event ID field has no special property at all and it is not an index to any other table so type change could be done.

Thanks in advance.

Gerardo

[Pig]

I'm not sure what you mean. You can already search either column, and index either as well. Can you clarify?

[tasistro]

Yes I can search the columns with independend indexes. I have two indexes one for the event ID (numeric) and one for the name field (full text). When I ask mysql to explain the query it tells me it uses the name field index and not the numeric. Problem is a name say tasistro can have many rows for many events. So once Mysql find the rows containing tasistro it has to search each row for the proper event without the help of an index. I need to include the eventID field in the name field index, but I can't seem to since eventID is numeric.