|
Home > Archive > MySQL ODBC Connector > April 2006 > searching for words with special chars
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
searching for words with special chars
|
|
| Octavian Rasnita 2006-04-01, 7:25 am |
| 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/mysql? unsub...sie.nctu.edu.tw
| |
| mysql@karsites.net 2006-04-01, 9:28 am |
| --655616-911986200-1143900180=:13465
Content-Type: TEXT/PLAIN; charset=ISO-8859-1
Content-Transfer-Encoding: 8BIT
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...n-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 <orasnita@fcc.ro>
> 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/mysql? unsub...ites
.net
>
>
--655616-911986200-1143900180=:13465
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
--655616-911986200-1143900180=:13465--
|
|
|
|
|