It's not clear to me whether you want the search to be case sensitive or not, but you need to make sure that the right collation is used. Case sensitive collations end in "_cs" and case insensitive collations end in "_ci".
Read about collations in chapter 10 of the manual: http://www.mysql.se/doc/refman/5.0/en/charset.html Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]