On Wed, Mar 26, 2003 at 03:00:43PM -0600, Lee Daniel Crocker wrote:
(Anthere
<anthere6(a)yahoo.com>)m>):
select l.cur_title, r.cur_title from cur l inner join
links lnk on binary l.cur_title = binary lnk.l_from
inner join cur r on binary r.cur_title = binary
lnk.l_to where r.cur_text like '%#redirect%'
"where ... like '%..." is a no-no, especially on a
join, as it will cause a full search of every record.
Note that if we were running PostgreSQL, we could set timeout limits on
a per user basis. :P
--
Nick Reinking -- eschewing obfuscation since 1981 -- Minneapolis, MN