I see from the debug consol that it appears to be quereing all relevant fields you would want/expect, but still the results seem limited to item name.
#
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-05-25 00:29:37' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-05-25 00:29:37' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('terrain')
ORDER BY i.id DESC
LIMIT 0, 10
Gamal Andrews said:You are correct case. It seems only to be searching the items name. How do you broaden it to everything? Thanks again William, you got me this far.