Subject | Re: Search strategy |
---|---|
Author | Ian A. Newby |
Post date | 2004-04-19T13:27:35Z |
Hi Bob,
try,
select
c.article
from
content c
join keyword k1 on (c.content_id = k1.content_id)
join keyword k2 on (c.content_id = k2.content_id)
join keyword k3 on (c.content_id = k3.content_id)
where
k1.word = 'firebird' and
k2.word = 'database' and
k3.word = 'search'
Regards
Ian Newby
try,
select
c.article
from
content c
join keyword k1 on (c.content_id = k1.content_id)
join keyword k2 on (c.content_id = k2.content_id)
join keyword k3 on (c.content_id = k3.content_id)
where
k1.word = 'firebird' and
k2.word = 'database' and
k3.word = 'search'
Regards
Ian Newby