I need to be able to check and see in a certain string is anywhere within my SQL table. The table I am using only has one column of char's. Right now it is saying that everything entered is already within the table, even when it actually is not.

Within SQL I am getting the rows that have the word using this:

```
SELECT * FROM ADDRESSES WHERE STREET LIKE '%streeetName%';

```

However, in PHP the word is being entered by the user, and then I am storing it as a variable, and then trying to figure out a way to see if that variable is somewhere within the table.

```
 $duplicate = mysql_query("SELECT * FROM ADDRESSES WHERE STREET_NAME LIKE '%$streetName%'", $connect);
    if(!empty($duplicate))
    {
       echo "Sorry, only one of each address allowed.<br /><hr>";
    }

```