Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: Many-to-many relationships in databases

by davorg (Chancellor)
on Oct 28, 2005 at 12:28 UTC ( [id://503629]=note: print w/replies, xml ) Need Help??


in reply to Re: Many-to-many relationships in databases
in thread Many-to-many relationships in databases : SOLVED

Just convert everything to upper case. Far more efficient than using LIKE unnecessarily.

SELECT book
FROM   BooksAuthors AS B1
JOIN   BooksAuthors AS B2
ON     B1.Book = B2.Book
WHERE  UPPER(B1.Author) = 'JONES'
AND    UPPER(B2.Author) = 'SMITH'

[download]
--
<http://dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://503629]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others wandering the Monastery: (1)
As of 2024-04-25 04:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found