Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
Solved
Ignoring punctuation in full text search
Posted on 2004-10-01
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
1. Add punctuation to your stopword list?
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.
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.
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
Featured Post
![[eBook] Windows Nano Server](https://filedb.experts-exchange.com/files/public/2017/6/24/1329f749-2f43-4bd1-8413-3b5b5ab33fc6.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows the steps required to install WordPress on Azure.
Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan.
WordPress is no exception and requires an App Service Plan and Database to install
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
- Server Hardware
- IT Administration
- Disaster Recovery
- Storage Software
- Databases
- Storage Hardware, MySQL Server, Hardware, Percona, *Backups
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month7 days, 19 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.