Hello!

    I have found that  in "quick search", the words are also matched to categories.comments. If the searched word is found in this field, then the results include , in addition,  all the items of this category. How can I avoid this?

Ex: CATEGORIES.COMMENT

ID, DATE_LAST, NB_IMAGES, NAME, ID_UPPERCAT, COMMENT, ...
9, '2008-10-08 18:23:46', 559, 'Ferretería', , 'Referencias de artículos generales para la ferretería doméstica ( ensamblajes, CUELGAFACIL,  imanes, llaveros, candados,...)', ...


SELECT id, name, permalink, nb_images
  FROM categories
    INNER JOIN user_cache_categories ON id=cat_id
  WHERE user_id=1
    AND MATCH(name, comment) AGAINST( "cuelgafacil" IN BOOLEAN MODE)

(**Word "CUELGAFACIL" is found in in "comment" field of category number 9 **)


SELECT DISTINCT(id)
  FROM images i
    INNER JOIN image_category AS ic ON id = ic.image_id
  WHERE (i.id IN (1070,1068,1067,1066,1065)<---- Id's correspondig to my quick search of "Cuelgafacil": OK!
    OR category_id IN (9))          <-------------------------------- I want to avoid this restriction!!
AND 1 = 1
ORDER BY date_available DESC, file ASC, id ASC


I hope I have explained my problem correctly. Thanks for your help!

Last edited by manute (2008-11-17 15:51:16)