[Proof99]

How do I delete user names or values from fields in databases? For instance:

In database: Names

Table: Fred

Field: username

How would I delete a or user name specific value from the field username?

[End User]

Originally Posted by Proof99

How would I delete a or user name specific value from the field
username?

In phpMyAdmin, if the name to be deleted was, for example, "OneMoreTime", you'd go to the "SQL" tab and type:

DELETE FROM Fred WHERE username = 'OneMoreTime' LIMIT 1

Then you'd click the 'Go' button.

Note that by default, mySQL doesn't operate in a case-sensitive manner, so if you had the names "OneMoreTime", "ONEMORETIME", and "onemoretime" in the table, whichever one was found first would be the one that was removed. Without the "LIMIT 1" clause they would all be removed.