# How to check all rows in database except 1 particular row?

**URL:** <https://forum.kirupa.com/t/how-to-check-all-rows-in-database-except-1-particular-row/322241>\
**Category:** Uncategorized\
**Created:** [May 16, 2011, 1:34am UTC](https://forum.kirupa.com/t/how-to-check-all-rows-in-database-except-1-particular-row/322241 "2011-05-16T01:34:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![celestale](https://avatars.discourse-cdn.com/v4/letter/c/9fc348/32.png) [@celestale](https://forum.kirupa.com/u/celestale)\
**Post date:** [May 16, 2011, 1:34am UTC](https://forum.kirupa.com/t/how-to-check-all-rows-in-database-except-1-particular-row/322241/1 "2011-05-16T01:34:35Z")

</div>

Hi, this is my code to check the whole database, but how do I check the whole database except for 1 particular row? Taking into consideration that I have an unique ID for every row. so I’m able to do something that checks for all the ID except this ID.

```auto
$check_query = "SELECT COUNT(*) AS count FROM participants WHERE email = '$email'"; 
$result = $connection->query($check_query); 

```

Thank you for reading!