I have a functional fulltext search engine. I'm trying to remove entries from the query though based on a condition that'll come back with each entry.
So for example, let's say I have 2 different kinds of entries in this table. And there's a field in the database called 'origins'.
Right now - there's only 2 'origins' - but I'm trying to build this so that there can be 50 or 100 in the future.
And the origin field will have text like "pr_1" or "pr_1; pr_2".
What I want to do is take the fulltext return and test this field in each response to see if "pr_2" is in it. If it's NOT - then I'm basically telling the response that the search return pulled a row that doesn't belong to the appropriate origin. Can I remove these rows from the search return AFTER the array has come back? I need to have all those rows pulled out and the final count of the number of articles returned correctly. I also have a pagination system running and need to make sure that the pages/etc reflect the corrected number of returns.
Help,advice, suggestions? Thanks in advance.
