String Manipulation

["Jeffrey G. Ubalde" <suppressed>]

Good day list!


I have been thinking about this for hours, and I cant quite get the
correct keyword for me to search it in the manual.

for example i have a field that contains string1:string2:string3
where colon ':' is the delimiter.

How do i create a select statement that only returns string2?


Thank you all in advance.

-- 
Jeffrey G. Ubalde
Business Systems
Meridian Telekoms Inc.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed