mysql- returning first 'x' characters?

[adamhhh1]

bit stumped here, how do i return the first x amount of characters from a field in a mysql database?

[Lars_Berg]

select substring(columnName from 1 for 12), ...