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]

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'd

RE: multiple values in one column

2003-11-13 Thread John Berman
November 2003 14:14 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: multiple values in one column 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

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

RE: multiple values in one column

2003-11-13 Thread John Berman
. 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 have a single

Multiple values for a column

2001-07-17 Thread Chip Carpenter
Hi all, I'm fairly new to MySQL and to SQL in general, but not a complete newbie. I have the o'reilly book, as well as dubois and the SAMS PHP MySQL books . . . I think I know the answer to the question but I want to make sure I'm not missing anything I'm building a database that will list

Re: Multiple values for a column

2001-07-17 Thread Chip Carpenter
Hi again, I've been given a better solution (wow you guys are speedy!), which is to use an application_os junction table, which is the thing I was missing . . . I was thinking of the junction table wrong, Thanks! If anyone has any other suggestions, they will be appreciated, it's just that