> > From: Bruce Therrien <[EMAIL PROTECTED]> > Date: 2003/11/28 Fri PM 01:42:14 CST > To: [EMAIL PROTECTED] > Subject: Retrieving info from a Joined column > > We ahve a column in our table that has > new info added each time using a JOIN function. > The data is separated using a : separator.
This doesn't answer your question... However, note that in most instances using columns with multiple values is a bad idea in a relational database. If possible, you'd be better off with a design that does not require multiple values in a single column. > > How does one retrieve this info from the colomn and put it > into list format, or check for duplicates, or do a search > in the column for a certan string. > We use PERL for all database entries and retrievals. > > Sample data > > 1223:1897:9807:36754:20875 > > Thanks, > -- > Bruce Therrien <[EMAIL PROTECTED]> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
