I have a web-based program with MySQL database. I need to do a full text search on three fields. How can I do it? Use ‘LIKE’ is very slow, when I need combination of different situation. So I find FULLTEXT index of MySQL.