SELECT *
FROM `table`
WHERE `column` LIKE _utf8 '%word with accent%' COLLATE utf8_unicode_ci;

That will work.
:cool: