Searching Indexes using key name

[rondog]

Can I write a query to search by using the keyname rather than entering all the fields?

 

For example, I have a colA,colB,colC indexed with a keyname searchableFields

 

Right now I write:

SELECT * FROM table WHERE MATCH(colA,colB,colC) AGAINST($someVar)

 

I want to be able to just do it like this:

SELECT * FROM table WHERE MATCH(searchableFields) AGAINST($someVar)

 

When I do that, I get a:

#1191 - Can't find FULLTEXT index matching the column list

 

error. Any ideas?

[fenway]

That's not an option -- just list the column names -- what's the problem?

[rondog]

That's not an option -- just list the column names -- what's the problem?

 

I have many columns, about 15 and it would just be easier to do keyname

[fenway]

If you really wanted, you could look up the index column in mysql's table, but it seems like a bother.