Asplund [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 1:26 PM
To: Chris Boget
Cc: [EMAIL PROTECTED]; MySQL
Subject: Re: Stumped on a query
On Tue, 20 Jan 2004, Chris Boget wrote:
> > > The data I'm working with looks like this:
> > > table1.columnA = '1;3;4
On Tue, 20 Jan 2004, Chris Boget wrote:
> > > The data I'm working with looks like this:
> > > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > > table2.columnA = '3';
> > > table2.columnB = 'this';
> > > I need to write a query that will do something along these lines:
> > > SELECT * FROM table1,
On Tue, Jan 20, 2004 at 03:02:45PM -0600, Chris Boget wrote:
> > > The data I'm working with looks like this:
> > > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > > table2.columnA = '3';
> > > table2.columnB = 'this';
> > > I need to write a query that will do something along these lines:
> > > SE
> > The data I'm working with looks like this:
> > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > table2.columnA = '3';
> > table2.columnB = 'this';
> > I need to write a query that will do something along these lines:
> > SELECT * FROM table1, table2 WHERE
> > table2.columnB = 'this'
> > AND
>
On Tue, 20 Jan 2004, Chris Boget wrote:
> The data I'm working with looks like this:
>
> table1.columnA = '1;3;4;6;8;9;12;13;14;15';
>
> table2.columnA = '3';
> table2.columnB = 'this';
>
> I need to write a query that will do something along these lines:
>
> SELECT * FROM table1, table2 WHERE
>
I'm working with data that has not been normalized. If it were
up to me and I had the time, I'd go in and change all the code
so that the data were normalized, but right now that's not an
option.
The data I'm working with looks like this:
table1.columnA = '1;3;4;6;8;9;12;13;14;15';
table2.colum
