Louie,
Mysql treats the dash as a word separator. There's no way to change
that unless you change the source code and recompile Mysql.
Also, the default min word length is 4. So not only is "E" not
matched; even "018" will not be matched. The min word length is easily
configurable, though. Put a
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
> 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?
I'm not an expert but others will correct me :
In a fulltext search, the search string must be at least 4 char
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 |
+---+--+--+-+-+-