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.