Ignoring punctuation in full text search
1) Is there a way to set up a full text search to ignore punctuation?
2) Is there a way for a full text search to give higher priority to a certain field when ranking the results?
2) Is there a way for a full text search to give higher priority to a certain field when ranking the results?
Asked:
Who is Participating?
you can use BOOLEAN search in FULLTEXT ..Refer here:
http://www.databasejournal.com/features/mysql/article.php/1587371
http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html
http://www.databasejournal.com/features/mysql/article.php/1587371
http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month7 days, 14 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
2. In general not really. You can create separate full-text indexes on each field then search first one field then another and sort the rows like that, but otherwise I don't know of a built-in way to do it. MySql returns full-text rows based on it's relavence estimation and not what field contained the data for that row.