On Wed, Mar 26, 2003 at 03:00:43PM -0600, Lee Daniel Crocker wrote:
(Anthere anthere6@yahoo.com):
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