subject:"FIND_IN_SET index problem"

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) 0;

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;