The INTERSECT keyword is not available in MySQL. You will have to compare
the columns in your join syntax (or get creative?).
-Original Message-
From: L a n a
To: [EMAIL PROTECTED]
Sent: 7/18/04 8:20 PM
Subject: how to intersect resulting sets form sql query
Hello,
I'm trying to find
INTERSECT is not a MySQL keyword. If I read your logic correctly, you
seem to want:
SELECT *
FROM table
WHERE (field_a like '%keyword1%' OR field_b like '%keyword1%')
AND (field_a like '%keyword2%' OR field_b like '%keyword2%')
This statements tests that both keyword1 and keyword2
Hello,
I'm trying to find a resulting set for searching two keywords, like:
Select * from table where filed_a like '%keyword1%' OR field_b like
'%keyword1%' INTERSECT (Select * from table where filed_a like '%keyword2%'
OR field_b like '%keyword2%').
This statement gives an error in syntax.
What