SQL query with Unicode codepoints in SQLite and MySQL

What is the right way to use unicode codepoints in a query? (SQLite and MySQL):

sqlite> select name from city where name like '%rich';
Zürich
Zurich

I tried using the codepoint but nothing worked so far:

sqlite> select * from city where name like 'Z\u00fc%';
(empty)

Anybody? Thanks