Full Text index doesn't math the column list

[webguync]

Hi,

 

I am working on a form that will bring up data from the MySQL tables. I did some research and realized I needed to a mult-column full-text index in order for the search application to work. In PHP MyAdmin under the SQL area I added this statement.

CREATE FULLTEXT INDEX SearchMe ON ResultsTable (col1,col2, col3.col4,col5); 

 

I tried the search application again and get this error.

SELECT col1, col2,col3,col4,col5 FROM ResultsTable WHERE MATCH(col1, col2,col3,col4,col5) AGAINST ('SearchName')

 

When I enter the SQL code in PHPMyAdmin the result says

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

 

so I need to figure out which columns got indexed and which are not or why they don't match up. How can I do this?

[fenway]

What's col3.col4?  That doesn't make any sense.

[webguync]

it's the names of the columns in my table. I was just using dummy names instead of the real ones (last_name, first_name etc.)

[fenway]

Well, since you're getting a real error, and not a dummy one, tell us what's actually going on.

[webguync]

it looks like I figured out my own problem, thanks.

[fenway]

Great -- now tell us what it was.

[webguync]

it was a matter of indexing columns that I inadvertently didn't included in my Select list.

 

SELECT col1, col2,col3,col4,col5 FROM ResultsTable WHERE MATCH(col1, col2,col3,col4,col5) AGAINST ('SearchName')

 

when I added all of the columns, I no longer got an error.