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
