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
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)
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
