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

Development Tools Database Foundations Creating Tables and Manipulating Data with SQL Inserting, Updating and Deleting Rows

pi R
pi R
12,720 Points
Posted by pi R
pi R
12,720 Points

MySQL UPDATE and Wildcard doesn't works?

Hi ! On the MySQL Database Foundation course, the part in stage 4 : "Inserting, Updating and Deleting Rows."

UPDATE movies SET year = 2009 WHERE title="Avatar"; works perfectly.

I tried to do the same using a wildcard :

UPDATE movies SET year = 2009 WHERE title="Ava%"; and it doesn't work!

Can anyone explain me why? Thanks !

1 Answer

pi R
pi R
12,720 Points
pi R
pi R
12,720 Points

Nvm, I found the problem. I should have used the keyword LIKE instead of "="

UPDATE movies SET year = 2009 WHERE title LIKE "Ava%";