Something

 SELECT COUNT( * ) AS count
FROM `carlbro_walmo`.`Abbrev`
WHERE `abbrev_id` LIKE CONVERT( _utf8 '%red%'
USING )
COLLATE OR `abbrev` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `abbrev_type` LIKE CONVERT( _utf8 '%red%'
USING )
COLLATE OR `country` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `state` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `canada_prov` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `desc` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `link_loc` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `create_dt` LIKE CONVERT( _utf8 '%red%'
USING )
COLLATE OR `create_by` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `modify_dt` LIKE CONVERT( _utf8 '%red%'
USING )
COLLATE OR `modify_by` LIKE CONVERT( _utf8 '%red%'
USING latin1 )
COLLATE latin1_swedish_ci 

Partial error message using MySQL 5.0.22 and PhpMyAdmin (2.4.2 I think)