FGH
public text v1 · immutable// MYSQL QUERY:
SELECT *, match(pages.text) against('$search_keywords' in boolean mode) as relevance
FROM pages, menu
WHERE match(pages.text) against('$search_keywords' in boolean mode)
@@AND (pages.id = menu.type_id)
AND menu.hidden <> 1
ORDER BY relevance desc
// This query still fetches pages that it shouldn't (pages with menu.hidden = 1).
// I'm new to this.. what am I doing wrong ?
// Thanks!