RE: multiple values in one column

2003-11-13 Thread John Berman
gle column. Regards John Berman -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 21:32 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: multiple values in one column On Thursday, Nov 13, 2003, at 12:03 US/Eastern, John Berman wrote: > I

Re: multiple values in one column

2003-11-13 Thread Parker Morse
On Thursday, Nov 13, 2003, at 12:03 US/Eastern, John Berman wrote: I have a single table with 120 fields (its full of genealogical data) All the records apart from marriages have an entry in the surname field [snip] Now marriages don't have an entry in surname but they do in groomsurname and bri

RE: multiple values in one column

2003-11-13 Thread John Berman
s a problem. Any help would be appreciated. Regards John Berman -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 14:14 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: multiple values in one column On Thursday, Nov 13, 2003

Re: multiple values in one column

2003-11-13 Thread Parker Morse
On Thursday, Nov 13, 2003, at 02:55 US/Eastern, John Berman wrote: Can I have multiple values in one column and then index the column, I have used different delimiters but the index only seems find the whole contents of the column no matter what I separate the data with It seems like you'

multiple values in one column

2003-11-13 Thread John Berman
Hi Using MySql 3.23 Can I have multiple values in one column and then index the column, I have used different delimiters but the index only seems find the whole contents of the column no matter what I separate the data with Regards John Berman [EMAIL PROTECTED]