[TYPO3-dev] A search query question

[Sacha Vorbeck]

Hi,

> Commonly there are queries like pid IN (...)
> 
> But I would need opposite (list of pages, which must exclude from seach) 
> and pid NOT IN (...) didn't work - what's the correct

not a direct answer to your quetion but: IN is powerful as it can 
contain a sub-query but often find_in_set is sufficient and you can 
easily negate it:

SELECT line, category
FROM lines
WHERE FIND_IN_SET('4',category)>0;

-- 
all the best,
Sacha