this is a working example i found on mysql.com
this is my example of fullsearch
mysql> desc fullsearch;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| title | varchar(200) | YES | MUL | NULL | |
| body | text | YES | | NULL | |
+-------+------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
my data:
mysql> select * from fullsearch;
+----+-----------------------+-----------------------------------------------+
| id | title | body |
+----+-----------------------+-----------------------------------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... |
| 2 | How To Use MySQL Well | After you went through a ... |
| 3 | Optimizing MySQL | In this tutorial we will show ... |
| 4 | 1001 MySQL Tricks | 1. Never run mysqld as root. 2. ... |
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 6 | 018-E | Test for Title Item COde search language, etc |
| 7 | MySQL Security | When configured properly, MySQL ... |
+----+-----------------------+-----------------------------------------------+
my search the title with a "-" code
mysql> select * from fullsearch where match (title,body) against ('018-E');
Empty set (0.00 sec)
it returns an empty set, is it possible to also search with "-" dash? chars?
--
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
