Results 1 to 2 of 2

Thread: search query

  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: search query

    I am trying to build a search engine and I've run into a little problem with exclude from results- can anyone see what is wrong with this statement....

    Code:
    SELECT archive_search_wordmatch.unique_id 
    FROM archive_search_wordmatch 
    INNER JOIN archive_search_wordlist 
    ON (archive_search_wordmatch.word_id = archive_search_wordlist.word_id) 
    WHERE archive_search_wordlist.word_text IN ('fruit') 
    AND NOT EXISTS ( SELECT archive_search_wordlist.word_id FROM archive_search_wordlist WHERE archive_search_wordlist.word_text IN ('apple','pear','orange') ) 
    GROUP BY archive_search_wordmatch.unique_id LIMIT 0, 5000

  2. #2
    Join Date
    Mar 2008
    Posts
    11
    nevermind I found it....

    http://www.pui.ch/phred/archives/200...e-schemas.html


    This is from 2005, I guess it still aplies

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •