-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I realized this also. Martin Schwarz off list suggested to me to use
REGEXP for that purpose. That means that I'm rewriting the user input
"übersee" behind the scenes to "^(ü|ue)bersee.*" which works quote well.
The only gotcha is that the user m
MySQL doesn't have anything like that. You can use the wildcard
characters instead of the umlauts if you want, such as
SELECT * from person where name like "%bersee"
which would get
"übersee" and "uebersee"
but also a whole lot more.
But doing something like
SELECT * from person where name like