All pastes #70168 Raw Edit

FGH

public text v1 · immutable
#70168 ·published 2006-06-23 21:05 UTC
rendered paste body
// 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!