Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql> select left(ftText,20) from Txt_index where match(ftText)
> against('+(wщd200206*) +wщ12p' in boolean mode);
+----------------------+
| left(ftText,20) |
+----------------------+
| wщd20020601 wщ12p wщ |
| wщd20020604 wщ12p wщ |
| wщd20020604 wщ12p wщ |
+----------------------+
3 rows in set (0.36 sec)
mysql> select left(ftText,20) from Txt_index where match(ftText) against('+wщd200206*
> +wщ12p' in boolean mode);
+----------------------+
| left(ftText,20) |
+----------------------+
| wщd20020601 wщ12p wщ |
| wщd20020601 wщnw wщ1 |
| wщd20020604 wщ12p wщ |
| wщd20020604 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020609 wщ12p wщ |
| wщd20020611 wщ12p wщ |
| wщd20020611 wщ12p wщ |
| wщd20020611 wщ12p wщ |
| wщd20020611 wщ12p wщ |
| wщd20020611 wщ12p wщ |
| wщd20020614 wщ12p wщ |
| wщd20020614 wщ12p wщ |
| wщd20020619 wщ12p wщ |
| wщd20020619 wщ12p wщ |
| wщd20020619 wщ12p wщ |
| wщd20020619 wщ12p wщ |
| wщd20020619 wщ12p wщ |
| wщd20020625 wщ12p wщ |
| wщd20020625 wщ12p wщ |
| wщd20020625 wщ12p wщ |
| wщd20020625 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
| wщd20020627 wщ12p wщ |
+----------------------+
42 rows in set (8.00 sec)
mysql> show variables like 'version';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| version | 4.0.2-alpha-log |
+---------------+-----------------+
1 row in set (0.00 sec)
--
Best regards,
Artem mailto:artem@stripped
