Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Course Of The Month
9 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Foreword
This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php). Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface.
Change Cu…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 2 hours left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.