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:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
