• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1124
  • Last Modified:

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?
0
dovcamp
Asked:
dovcamp
1 Solution
 
petoskey-001Commented:
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now