about full text search
Hi all, I'm new to full text search mode in mysql.
Here are few simple question which i wish to know:
1. 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?
2. 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.
1. you can, yes, but there would be no point
2. LIKE %...% is very, very slow
Thank you for your sharing, r937.. ;)
Originally Posted by r937