Why does this work?

select * from Table where SomeField like '%%';

This will result in a hit with text that has no funny character like in it at all. This happens alot. With all kinds of strange characters, I'll do a search like that and it will come up with plenty of results but all kinds of the results will have no funny characters whosoever.

Mysql 4.0.24
Linux 2.4