Did you try the first query again? Is it possible that another
"Szczech" was added in the time you did both queries? What happens
when you the simple
mysql> select id_c, name, from clients where name like 'Szczec%';
and
mysql> select id_c, name, from clients where name like 'Szczech';
and most importantly
mysql> select id_c, name, from clients where name = 'Szczech';
The answers to those will help figure out what's going wrong.
-Sheeri
On 5/31/06, Lukasz Budnik <lukasz.budnik@stripped> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
