: > 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
Most likely you're referensing different tables. Make sure
that "yellowtest.Yellow" in the second query in fact points to "Yellow"
database meant in the first query.
Sherzod
---------------------------------------------------------------------
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
