Returning results as a field name

[Mark Dale]

Hello MySQL List

I have a simple table that outputs results like so:

select name, question_id, answer from table;
      +-------+--------------+---------+
      |NAME   |QUESTION_ID   |ANSWER   |

      +-------+--------------+---------+
      |Mark	  |100	     |Yes	   |	
      |Mark	  |101	     |No	   |
      |Leigh  |100	     |Yes      |	
      |Leigh  |101	     |No	   |
      +-------+--------------+---------+	

 Is there a way to query things so the result looks like this:
      	
      select ???
      +--------+-----------+-----------+
      |NAME    |100        |101        |
      +--------+-----------+-----------+
      |Mark	   |Yes	   |No         |
      |Leigh   |No	   |Yes	   |	
      +--------+-----------+-----------+

cheers

Mark Dale

mark.dale@stripped