Hello. Perhaps it is an issue of your collation:
mysql> select a from ts where a like '%ó%' collate utf8_bin ; +----------------+ | a | +----------------+ | Mester József | +----------------+ 1 row in set (0.00 sec) mysql> select a from ts where a like binary '%ó%'; +----------------+ | a | +----------------+ | Mester József | +----------------+ mysql> select a from ts where a like '%ó%'; +----------------+ | a | +----------------+ | Mester József | | Job György | | Czibere Lajos | +----------------+ See: http://dev.mysql.com/doc/refman/5.0/en/charset-collations.html Mester József wrote: > Hy > > I have a table datas like that : > name > Mester József > Job György > Czibere Lajos > > If I create : > > select name from dolgozok where name like '%jó%' ; > > then all data will be shown. > But I wolud like see datas which really contain ó character (only Mester > József). > > Joe > > > > --------------------------------- > Win a BlackBerry device from O2 with Yahoo!. Enter now. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
