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]