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
: 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