title: Convert query from "LIKE" query to "MATCH AGAINST" (FULLTEXT index )
body: <p>Hi Below is my query in which I am using "LIKE" on prenom and nom fields in sql. I want to convert that query into MATCH AGAINST so, I can use FULLTEXT index applied on those fields. Need suggestion.</p>
  
  <pre><code>SELECT `Pers`.`persID`, `Pers`.`name`, `Pers`.`nom`, `Pers`.`prenom` 
  FROM `bdrplus`.`pers` AS `Pers`   
  WHERE `Pers`.`prenom` LIKE 'j%' AND `Pers`.`nom` LIKE 's%' AND `Pers`.`etat` = 1   
  ORDER BY  `Pers`.`prenom` ASC, `Pers`.`nom` ASC
  </code></pre>
  
  <p>How can I write above query with MATCH and AGAINST in mysql?</p>