Simple Query Problem

SELECT clrId,clrName, clrDesc, clrPicThumb FROM my_table WHERE MATCH (clrName) AGAINST ('red') AND active=1

There are more than 5 rows which have 'red' in name(clrName). This query returns zero result but query works fine for all other colors like 'green' or 'blue'. Why its not working for 'red'?

 

case sensitive? and active isn't 1? have u tried without active?

 

Case is not a problem. All are active.
Names are like this

Red Cotton Jersey Knit
Flannel Red
Red Dots on White
White Stripes on Red
Solid Red Woven

and so on....

 

Why not using like on the table? where 'field' like '%red%' does that solve the problem? if this works, the previous option should also work!?

 

From the manual:

Could that be your problem?