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 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 looking at it in a editor to see if you can see what may be wrong.
Also, reimport it back into a new test table and run your tests again.
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
