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 Securing and Maintaining a MySQL Database Indexing Columns in MySQL

Posted by Jim Eubanks
Jim Eubanks
3,780 Points

EXPLAIN SELECT * FROM users WHERE first_name = Pasan; is not working but I know it's correct

EXPLAIN SELECT * FROM users WHERE first_name = Pasan; is not working but I know it's correct

2 Answers

Gaylen Miller
Gaylen Miller
19,286 Points
Gaylen Miller
Gaylen Miller
19,286 Points

SQL needs to know what Pasan is. Right now it thinks it's a column name and is saying "I don't see that column". Putting quotes around it says "I'm a string". So changing it to ...WHERE first_name = 'Pasan' should do it.

Jim Eubanks
Jim Eubanks
3,780 Points
Jim Eubanks
Jim Eubanks
3,780 Points

That did it. Thank you