Re: Query Optimization

[Jani Patokallio]

MySQL is a relational database, not a spreadsheet, so your table structure is doomed to failure. Read up on database normalization:

http://en.wikipedia.org/wiki/Database_normalization

In short, reformat your table and data so that every attribute is one column:

id, name, brand, color, desc, price, year, site, address, url

Then your query is trivial:

select * from cars where name='Celica' and brand='Toyota' and year=1993;