MySQL Find Full Name Across Two Rows <p>I have a MySQL table where I'm trying to find a person by his full name. The problem is that first and last name are stored on two separate rows in the table as shown here:</p> <pre><code>+-----------------+-------------+-------------+--------------+ | submit_time | form_name | field_name | field_value | +-----------------+-------------+-------------+--------------+ | 1323463601.0947 | Online Form | firstname | Paulo | | 1323463601.0947 | Online Form | lastname | Hill | +-----------------+-------------+-------------+--------------+ </code></pre> <p>How can I construct a query that will get a single result (if possible) by searching for Paulo Hill?</p> <p>Also, the submit_time column should have the same value for both rows--that will be the one column value that is unique in the table.</p>