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… :wink: