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

Louis Darby
Louis Darby
5,149 Points
Posted by Louis Darby
Louis Darby
5,149 Points

MySQL queries.

Hi, I was wondering if it is possibly to SELECT from a single column in a table but then retrieve the row data for that item.

For example, selecting an id column to search for an id rather than selecting all columns and then retrieving data from that row with the chosen id.

Is this possible with a query/ fetch or PDO method?

Thanks.

1 Answer

Jon Orri Leosson
Jon Orri Leosson
9,506 Points
Jon Orri Leosson
Jon Orri Leosson
9,506 Points

I think you have to select some columns or all of them and use the WHERE clause to specify the id you want to get.

SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;