Delet row that contains ....

[Worqy]

Hi.

 

I need help with a PHP script that deletes mysql data.

Is there some way to delete a sql row by only telling the data stored in it.

Let say I have  a table called "Users", with columns "Username" and "Password".

Can I somehow delete is like this "DELETE FROM Users WHERE IT CONTAINS 'Kevin', 'Secret'"

now it would search and see if there is any like with that data on it.

 

I need it because I have a table with unknown column names, I only know the data stored.

[trq]

I have a table with unknown column names

 

That makes no sense.

[AyKay47]

i agree, that last statement makes no sense at all, nor does your entire statement really..

however if you want to choose what data to delete you will want to use the WHERE clause..

 

$sql = "DELETE FROM table WHERE username = 'username' AND password = 'password'";