How to search double quotes in fulltext search in sql?

Php coding to make sql search query with four drop down combo boxes.?

• My sql table named pets. Columns named breed, color, size, gender, postal code. Html page has four drop down boxes named the same, with different options for selection in them. I want to make a sql query where when one option, say breed Akita is selected, the rows for all the akita's with different characteristics mentioned are displayed in the same page. Same with the other columns. Postal code column should be searched as a text box. It might sound easy, but I ve been breaking my head as I don't find an answer. Thanks for your help.

• Answer:

  "I want to make a sql query where when one option, say breed Akita is selected, the rows for all the akita's with different characteristics mentioned are displayed in the same page." Are you looking for PHP code or a SQL query? The query is straightforward as what you're describing is just a simple: SELECT * FROM pets WHERE columnName = 'columnValue' For example, SELECT * FROM pets WHERE breed = 'Akita'