MYSQL data exclusion

[SlowRunner]

I'm trying to write a report that will display a certain number of characters from within the middle of a populated field. i.e. I want to show/display 6 characters from within a group of 100 characters.

Any ideas on this?

Thanks,

SlowRunner

[chazzy]

mysql has a substr/substring function

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substr