PJ wrote:
I hope somebody can make sense of this.
First, I don't understand what the difference is supposed to be between
and - is there a difference for php and/or mysql?
Second, I am trying to select all occurrences in a table.column where
the first letter of the name is I, J, or K but not I
Kyle Smith wrote:
PJ wrote:
I hope somebody can make sense of this.
First, I don't understand what the difference is supposed to be between
and - is there a difference for php and/or mysql?
Second, I am trying to select all occurrences in a table.column where
the first letter of the name is
Kyle Smith wrote:
Kyle Smith wrote:
PJ wrote:
I hope somebody can make sense of this.
First, I don't understand what the difference is supposed to be between
and - is there a difference for php and/or mysql?
Second, I am trying to select all occurrences in a table.column where
the first
PJ wrote:
Kyle Smith wrote:
Kyle Smith wrote:
PJ wrote:
I hope somebody can make sense of this.
First, I don't understand what the difference is supposed to be between
and - is there a difference for php and/or mysql?
Second, I am trying to select all occurrences in a
PJ,
On Wed, Apr 1, 2009 at 1:40 PM, PJ af.gour...@videotron.ca wrote:
SELECT * FROM book
WHERE id IN (SELECT bookID
FROM book_author WHERE authID IN (SELECT author.id
FROM author WHERE LEFT(last_name, 1 ) = '$Auth'
LEFT(last_name, 1 ) = '$Auth1' LEFT(last_name, 1 ) =
Lex Braun wrote:
PJ,
On Wed, Apr 1, 2009 at 1:40 PM, PJ af.gour...@videotron.ca
mailto:af.gour...@videotron.ca wrote:
SELECT * FROM book
WHERE id IN (SELECT bookID
FROM book_author WHERE authID IN (SELECT author.id
http://author.id
FROM author
Thanks for that. I understand. Somehow, I had tried OR at one point but
I got one of those orange boxes probably for some other error and in the
confusion of my neurons I overlooked it.
However, I am puzzled that using (not ) did give a lot of results,
almost the whole db which is thankfully
7 matches
Mail list logo