Solved

Ignoring punctuation in full text search

Posted on 2004-10-01
2
1,078 Views
Last Modified: 2012-05-05
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?
0
Comment
Question by:dovcamp
[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
 
LVL 7

Accepted Solution

by:
petoskey-001 earned 125 total points
ID: 12201595
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.
0
 
LVL 32

Expert Comment

by:ldbkutty
ID: 12202968
0

Featured Post

Enterprise Mobility and BYOD For Dummies

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.

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.
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.

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.

Join & Ask a Question