Hi all, I’m new to full text search mode in mysql.
Here are few simple question which i wish to know:
-
Can I set all my text fields in the table to Full Text without caring whether they are use for searching purpose? Any bad effect to the page loading etc?
-
When shall we use search like %…% and full text search? I read few articles from website, full text search seems is a better choice since it search faster.