Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Calvin Secrest
24,815 PointsBummer! You should be searching for any full name that ends with Tolkien
In the e-commerce database we have a products table. The columns are id, name, description and price.Find all the products where the pattern 't-shirt' can be found anywhere in the product name.
Not understanding!
Calvin Secrest
24,815 PointsSure here is the link to the challenge below
1 Answer
Simon Coates
28,694 PointsI'm still a little confused about the products table explanation. However, the answers to the challenges for the link you gave me are:
select people_id, fullname from People where fullname like "%tolkien"
Select title
from Media JOIN Media_People On Media.media_id = Media_People.media_id
JOIN People ON Media_People.people_id = People.People_id
where People.fullname Like '%Tolkien'
SELECT title FROM Media
JOIN Media_People ON Media.media_id = Media_People.media_id
JOIN People ON Media_People.people_id = People.people_id
WHERE fullname LIKE '%Tolkien' and category="Books"
Calvin Secrest
24,815 PointsThanks for your support on this challenge
Simon Coates
28,694 PointsSimon Coates
28,694 Pointscan you post a link to the challenge? and the query you're trying. If you're getting a message about tolkien with that description of the challenge, treehouse may have a bug. I'd assume from the text you posted that the solution is something like:
but if i have a link to the challenge, i can test it out.