RE: Strange Updates

2003-02-11 Thread Sherzod Ruzmetov
: > 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'

re: Strange Updates

2003-02-11 Thread Victoria Reznichenko
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 = ''

Strange Updates

2003-02-11 Thread Daniele Lo Re
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 t