On Mon, Oct 18, 2004 at 11:19:55AM +0800, Louie Miranda wrote:
>
> 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?
If I remember correctly, you need to pass the string as a phrase to fulltext:
select * from fullsearch where match (title,body) against ('"018-E"');
I'd prefer being able to escape the - with \, since using a phrase has
other disadvantages (like partial word matching goes out the window),
but you can't.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
