On Tuesday 11 February 2003 16:21, Daniele Lo Re wrote:
> I got weird behaviour from Mysql while doing some updates.
>
> Before doing the update I did a count, like this:
>
>
>
> select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO
> +MIGLIOLI' IN BOOLEAN MODE) AND street_short = '';
>
> and the result was 50 rows in set.
>
> But when I ran the update:
> UPDATE yellowtest.Yellow SET street_short = 'MIGLIOLI' WHERE
> MATCH(street_add) AGAINST('+GUIDO +MIGLIOLI' IN BOOLEAN MODE) AND
> street_short = '';
>
> the result was:
>
> Query OK, 0 rows affected (1 min 53.89 sec)
> Rows matched: 0 Changed: 0 Warnings: 0
>
> I don't understand what's going on, since the WHERE clause is identical
> in both queries.
>
> What do you think?
It works fine for me ..
What version of MySQL server do you use?
Could you create a repeatable test case?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
