Can someone remind me again how I can cut a portion of a string from, say, point A to point B, dropping C-Z...

for example

ISBN# 1-894283-60-0 
6"x 9" • Trade paper • 300 pp 
$24.95 CDN • $19.95 US 
Number of Photos: 50 b/w 
BISAC subj. cat.: Music/Biography

All I's wants is the ISBN# 1-894283-60-0, chopping the rest off.
I'm assuming I can start from "ISBN" through to the first "\r\n", but what command would that be?
this block of text is held in a mysql TEXT column.

edit: *shamed* yes, explode() is obvious