04-15-2009, 12:48 PM
|
#1 (permalink)
|
|
The Frequenter
Join Date: Nov 2007
Location: Netherlands
Posts: 460
Thanks: 49
|
Selecting special characters in LIKE (mySQL)
Hey guys!
I've been trying to select information from a database using a LIKE query. Now the problem is, the users input could be something like 'agape', but in the database it could say 'agapè'. Vise versa of course, the user could input 'agapè' and the database could say 'agape'. Now, how do I match those two string to each other.
I've been trying and trying but I can't seem to get it to work. I've even read the mySQL manual partially but couldn't find anything...
Help? :)
ReSpawN
__________________
"Life is a bitch, take that bitch on a ride"
|
|
|