From: Date: February 17 2000 2:29pm
Subject: Re: Bibliographic databases
List-Archive: http://lists.mysql.com/mysql/28062
Message-Id: <87itzoc5yj.fsf@arjun.bates.net>

"Thimble Smith" <tim@stripped> writes:

> On Wed, Feb 16, 2000 at 10:32:09PM -0600, Douglas Bates wrote:
> >but for 'Able' and 'Charlie' I keep coming up with an empty set
> >
> >mysql> select a.* from articles as a, authors as w1, authors as w2 
> >    ->   where a.seq = w1.seq and w1.seq = w2.seq and w1.name like 'Able'
> >    ->   and w2.seq like 'Charlie';
> >Empty set (0.01 sec)
> >
> >I hope I am missing something obvious and you can enlighten me.
> 
> I'm afraid you will kick yourself very hard.  The last line above says
> "w2.seq like 'Charlie'".  I think you can figure out what is wrong with
> that little snippet, after looking at the values of authors.seq.  :)

Ah yes.  Rather embarrassing.

When I use "w2.name like 'Charlie'" it works much better :-)