in mysql (senza testarlo)
codice:
SELECT 
      CASE 
             WHEN colori LIKE '%rosso%' THEN 1
             ELSE 0
      END AS boolColori
FROM tabColori