To give a background my i have my column username as the primary key and it being unique. So lets say i have the following usernames...
bigal
bigal.albino
bigal.albino.matesic
tallecreative
dell
Now i would like to only delete the record with the username "bigal", but what happens is it deletes all that contains bigal in the username. Basically the first 3 usernames would be deleted.
What i think is happening is the query to delete the record contains a LIKE in the statement instead of it containing EQUAL. I can't seem to locate the delete query. Also I might be wrong too. If so, please correct me.
Thanks in advance,
Al
