Hi everybody
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?
Thanks
Daniele
---------------------------------------------------------------------
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
