Hi all!
I have a table that contains a column (blob, text type, formatted as
MEDIUMTEXT) with text hyphen (-) delimited, listing
rooms by numbers, and I need to export or insert that data into another
table, where all other info on the other columns remains the same, but I
need the data on the blob field to be single listed
another words, i have a table like this (example):
School Rooms
Your Hometown High School 1034-1035-1037-1039
My Hometown High School 208-178-1432-1728
I need it like this:
School Rooms
Your Hometown High School 1034
Your Hometown High School 1035
Your Hometown High School 1037
Your Hometown High School 1039
My Hometown High School 208
My Hometown High School 178
My Hometown High School 1432
My Hometown High School 1728
Suggestions? Thanks!
--
View this message in context:
http://www.nabble.com/Exporting-blob---text-column-with-hyphen-delimited-text-tf3854590.html#a10920903
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
