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