Lukasz Budnik wrote:
Hi All,I'm using 5.0.21 on Gentoo. I've got very strange problem. I have clients table with id_c and name columns. I'm running simple selects: mysql> select id_c, name, concat('#',name, '@'), length(name) from clients where name like 'Szczec%'; +-------+----------+---------------------------+------------------+ | id_c | name | concat('#',name, '@') | length(name) | +-------+----------+---------------------------+------------------+ | 30181 | Szczech | #Szczech@ | 7 | +-------+----------+---------------------------+------------------+ 1 row in set (0.00 sec) mysql> select id_c, name, concat('#',name, '@'), length(name) from clients where name like 'Szczech'; +-------+----------+---------------------------+------------------+ | id_c | name | concat('#',name, '@') | length(name) | +-------+----------+---------------------------+------------------+ | 30181 | Szczech | #Szczech@ | 7 | | 30693 | Szczech | #Szczech@ | 7 | +-------+----------+---------------------------+------------------+ 2 rows in set (0.00 sec) ups... what's going on? % stands for (m)any character(s) but returned 1 row, when % replaced with 'h' the same query returned 2 rows. I'm using latin2 charsets but 'h' is standard latin1 character. Any ideas? thanks in advance for any help best regards Lukasz Budnik
just a thought... Can you try OPTIMIZE TABLE... or REPAIR TABLE ... [EXTENDED] first then try those queries again HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
