Learn SQL basics in just 15 minutes with this tutorial focused on using SQL with MySQL. Topics covered include: - What SQL is and an overview of relational database management systems - Installing ...

Sorry. I know you were looking for a cleaner way of doing it but if I were in your situation, i'd stick the above in a View and use that.

SELECT a.au_id, t.title FROM titles t, authors a, titleauthor ta WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND t.title LIKE '%Computer%' SELECT a.au_id, t ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...