Re: FIND_IN_SET index problem

2002-07-27 Thread Benjamin Pflugmann
Hi. On Thu 2002-07-25 at 10:49:47 -0500, [EMAIL PROTECTED] wrote: > Hi, I have a problem where the index for a SET column does not get used > once I link in another table. > > The output to explain: > > mysql> explain select count(*) from NS_articles where > find_in_set('approved', artFlags)

FIND_IN_SET index problem

2002-07-25 Thread Monte Ohrt
Hi, I have a problem where the index for a SET column does not get used once I link in another table. The output to explain: mysql> explain select count(*) from NS_articles where find_in_set('approved', artFlags) > 0; +-+---+---+--+-+--+--+