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?
LVL 4
dovcampAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
petoskey-001Connect With a Mentor Commented:
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
 
ldbkuttyCommented:
0
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.