KT> The database has "Niсo" in it. I want it to be returned if the user KT> searched by using "nino" or "niсo".
Normalize words before using mysql. Use regexp to convert 'n' -> 'с'. 1.Create columns with normalized data. 2.Fill it. 3.Use columns with normalized data for search and use normalizing before start query. Sorry for my English. SoftSearch.ru Member of Independent Software Developers Forum (ISDEF) ICQ# 166233339 http://softsearch.ru/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]