How to create full text searchability in PHP webadmin?

[Scott Evans]

I am trying to create a full text search of my database but continue to get an error despite having indexed the TEXT columns (caption and location) under a single index (searches). How do I get the database to use full text searching?

A. I have added a SINGLE full text index on the two columns which are both of the TEXT type.

B. I have created a unique key using an image_id field(NOTE: none of the fields contain images; one contains a link that I will use to grab the image from a secure upload to my server. The reference is not contained in the search)

I type the query below in

Select * WHERE MATCH (caption) AGAINST ('denver');
 

However, I continue to get.

Error
SQL query: 
 
SELECT * 
FROM  `pictures` 
WHERE MATCH (
 
caption
)
AGAINST (
'denver'
)
LIMIT 0 , 30
MySQL said: 
 
#1191 - Can't find FULLTEXT index matching the column list 
 

All help is appreciated. Thanks.

[JKing]

If you have created a single index for caption and location it will only work when you search for both caption and location. In your query you are only searching caption therefore you need to make a separate index for caption.