title: How to set this full text index
body: <p>I would like some guidance in how to set the full text index in phpMyAdmin like following:</p>
  
  <p>Tables</p>
  
  <pre><code>universities:
  id
  name
  
  programs:
  id
  name
  university_id
  
  courses:
  id
  name
  program_id
  
  students:
  id
  name
  course_id
  </code></pre>
  
  <p>Search function
  User needs only to serach for students but I would like to create a full text of the students.name and the courses.name that match the students.course_id and so on so that the students name, course name (student participate in), program name (course is given in) and university name (program belongs to) is all searchable.</p>
  
  <p>Query
  If I construct it as above will the full text be created so that it is searchable like standard, e.g. with PDO:</p>
  
  <pre><code>$STH = $DBH-&gt;prepare('SELECT * FROM students WHERE MATCH(fulltext) AGAINST(:query IN BOOLEAN MODE));
  $STH-&gt;bindParam(':query', $query);
  </code></pre>
  
  <p>or how would the pdo query in look in php?</p>
  
  <p>Also will this be a heavy search function?</p>
  
  <p>Approx numbers: 5 universities, 100 programs 1 000 courses and 20 000 students.</p>