Does anyone know why this is happening? It seems like the double quote
matching isn't working...
-- Nick
mysql> SELECT count(id) FROM products WHERE MATCH (SearchData_AutoUpdate)
AGAINST ('"socket abcde"' IN BOOLEAN MODE) order by MATCH
(SearchData_AutoUpdate) AGAINST ('"socket abcde"' IN BOOLEAN MODE) desc;
+-----------+
| count(id) |
+-----------+
| 50 |
+-----------+
1 row in set (0.04 sec)
mysql> select count(id) from products where searchdata_autoupdate like
'%socket abcde%';
+-----------+
| count(id) |
+-----------+
| 0 |
+-----------+
1 row in set (0.03 sec)
mysql> select count(id) from products where searchdata_autoupdate like
'%socket%';
+-----------+
| count(id) |
+-----------+
| 70 |
+-----------+
1 row in set (0.02 sec)
mysql> select count(id) from products where searchdata_autoupdate like
'%abcde%';
+-----------+
| count(id) |
+-----------+
| 0 |
+-----------+
1 row in set (0.03 sec)
Server version 4.0.1-alpha on Solaris (official binaries)
---------------------------------------------------------------------
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
