selecting first character

[robsgaming]

In mysql when a query is ran, how do you select only the first character of a field? Like if the name of a game is mario, how do i get mysql to display "M" and not the full mario.

Thanks,

Rob

[xentrix]

SELECT LEFT ('name', 1) FROM table