title: What is the syntax to force the use of an index for a join in MySQL
body: <p>The use of the "FORCE/USE/IGNORE INDEX" when doing a straightforward select is well-documented, but it's not clear from the documentation how to do it for a JOIN.</p>
  
  <p>How do you force a specific index to be used for a joined table?</p>