How to output only MySQL rows with a certain value?

Answer 1

There are several methods for limiting the output of a query; joins, and a WHERE clause as an example. As an example lets say we have a Customer Table with the following rows CustomerID, FirstName, LastName, Address1, Address2, City, State, PostalCode Now that we have a table lets assume we want to retrieve all records from the table where the Customers LastName = WILLIAMS and they live in the State of Ohio (USA). This query would look like the following: SELECT CustomerID, FirstName, LastName, Address1, Address2, City, State, PostalCode FROM Customers WHERE LastName = 'Williams' AND State = 'OH' If you do not want all of the columns in the table then you would simply modify the SELECT clause to include only those columns that you wish to retrieve. In this example you will want an index on the table that includes the LastName and State fields.