FULLTEXT indexed?

Hi

I have a table that need to be fulltext indexted.

I have issued the appropriate command from the control panel, using:

ALTER TABLE RawrTable ADD FULLTEXT(RawrField);  

HTML:

But when I look at the table structure, it does not give me any clues if it is indexed or not.

is there any way to check the table for FULLTEXT by issuing a command (prefebly from control panel).

thanks for your time.

 

SHOW INDEX FROM RawrTable

Code (markup):

 

Hi

thanks for your reply.

I am abit new to php and mysql, I have done what you asked , but can not see any mention of FULLTEXT any where.

What should I be looking for?

ipbushes	0	PRIMARY	1	part_number	A	218	NULL	NULL		BTREE	
ipbushes	1	Desc	1	Descr	NULL	1	NULL	NULL	YES	FULLTEXT	
ipbushes	1	Description	1	Descr	NULL	1	NULL	NULL	YES	FULLTEXT	
ipbushes	1	Description_2	1	Descr	NULL	1	NULL	NULL	YES	FULLTEXT	
ipbushes	1	Description_3	1	Descr	NULL	1	NULL	NULL	YES	FULLTEXT	
ipbushes	1	Description_4	1	Descr	NULL	1	NULL	NULL	YES	FULLTEXT	

HTML:

all I get is this

 

Can't you see "FULLTEXT" there?

You can test it with something like this:

EXPLAIN SELECT * FROM `ipbushes` WHERE MATCH(`Desc`, `Description`, `Description_2`, `Description_3`, `Description_4`) AGAINST ('something' IN BOOLEAN MODE) LIMIT 1

Code (markup):

If you see "FULLTEXT" under "type", you'll know it works.

 

Hi

My apologies. Its there.

For some reason I didn't spot it there!!!
Time for opticians I think.

Cheers