Re: LIKE problem part II

2005-11-19 Thread Peczöli Zoltán
11/18/05 7:18 AM, Peczöli Zoltán at [EMAIL PROTECTED] wrote: The result of the second query matches that of the corresponding LIKE query, but the first seems to be correct. Any ideas what the problem might be? You are getting strange results. At this point I would suggest dumping the data, and

LIKE problem part II

2005-11-18 Thread Peczöli Zoltán
I tried to investigate my previous problem with statements containing LIKE clause on a specific table. The problem was basically the following: mysql> SELECT count(*) FROM user WHERE username LIKE 'o%'; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) m