On 11-Jul-01 Jaime Teng wrote:
> Hi,
>
> I have a table:
> mysql> describe crossref;
> +---+--+--+-+
>| Field | Type | Null | Key |
> +---+--+--+-+
>| word | char(15) | | MUL |
>| id| int(10) unsigned | |
Best I can come up with is something like
2 words:
SELECT c1.id
FROM crossref c1, crossref c2
WHERE c1.word='word1'
AND c2.word='word2'
AND c1.id=c2.id
3 words:
SELECT c1.id
FROM crossref c1, crossref c2, crossref c3
WHERE c1.word='word1'
AND c2.word='word2'
AND c3.word='wo
Hi!
Query:
-
select a.id
from crossref a
, crossref b
, crodsref c
where a.id=b.id
and a.id=c.id
and a.word= word1
and b.word= word2
and c.word= word3;
It isn't ideal construction, but it works.
For your example (two words - tintin & register):
select a.id from crossre