Well, that stinks. It SHOULD work, but.....

Heres a workaround:
Code:
 ...where concat(' ',products_name,' ') REGEXP '[^a-zA-Z]+red[^a-zA-Z]+';