Hi! Unfortunately, I get too many e-mails to handle help requests which are sent directly to me.
If you have purchased MySQL support, you may write to [EMAIL PROTECTED], and will get an answer quickly. If you would like to purchase support, please see the Support section of our web site: http://www.mysql.com/support/ If you do not want to purchase support, please send e-mail to the appropriate mailing list. We host several mailing lists related to MySQL: http://www.mysql.com/documentation/lists.html When you post your question, be sure to follow these hints about how to ask effective questions: http://www.mysql.com/documentation/mysql/commented/manual.php?section=Asking_questions On Jan 11, ICCFX wrote: > Hello Sergei, > > I know I shouldn't be mailing directly to you, but there is only one thing > in the whole SQL-world that I am fighting with.... you should be writing to [EMAIL PROTECTED] > I am trying out this FULLTEXT search, and it's real good! > But there is one thing that I still can't find... > > How can you search for words, containing non-alpha characters? > e.g. > > $result = mysql("db","SELECT *, MATCH title,body AGAINST ('song.mp3') AS > score FROM table WHERE MATCH (title,body) AGAINST ('$song.mp3')"); > > It ignores the '.' :( (or a minus sign, which is real text sometimes) > > Am I looking over something...? > Can you please help me out? > > Many thanks > Frederic MySQL splits words on non-alpha chars before putting them into index. so, you have two possibilities 1) make '-' and '.' legal word char - you have to alter ft_parser.c, word_char macro. 2) search like this MATCH (title,body) AGAINST ('$song') AND CONCAT(title,' ',body) LIKE '$song.mp3') Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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