Exporting and then importing the table helped, now both the regexp and the
like query produce the same result. I saved the table MYI file and will
keep experimenting with it, maybe I can come up with something useful.
Thanks for the idea.
Zoltan
On Fri, 18 Nov 2005, Scott Haneda wrote:
on 1
on 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
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
