There at least two ways to accomplish this. The easy way is to use the LIKE operator:
See http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html Regards Keith In theory, theory and practice are the same; in practice they are not. On Sat, 1 Apr 2006, Octavian Rasnita wrote: > To: mysql <mysql@lists.mysql.com> > From: Octavian Rasnita <[EMAIL PROTECTED]> > Subject: searching for words with special chars > > Hi, > > Is it possible to create a query that searches for records which contains > words with special chars and with their english correspondents? > > For example, if a user searches for "mata", I want to return all the records > that contain the words: > > mata > m?ta > mâ?a > mâ?? > > (just like Google does). > > Is it possible with MySQL, or I need to create all the possible combinations > in the client program, then search for all those words? > > Thank you. > > Teddy > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]