deleting specific SQL column data through PHP
<p>Hi I have a SQL table as below;</p>

<pre><code>--------------------------
col1 | col2 | col3 | col4|
--------------------------
 10  |  20  | 30   | 40  |
 15  |  22  | 12   | 21  |
 11  |  40  | 50   | 60  |
</code></pre>

<p>and I'm trying to delete column specific data from the table. For instance I want to delete 50 and 60 in respective 3rd and 4th columns.</p>

<p>I use the following code but it deletes the entire row which contains 11 and 40 as well. Code is as follows. can some one tell me how to alter my approach below? Thanks.</p>

<pre><code> $result = mysqli_query($con,"DELETE FROM table1 WHERE col1 ='11'");
</code></pre>
