find row from mysql table with multiple parameters (from different columns) using php

Question

I have a mysql table as below:

--------------------
| Sl | col1 | col2 |   
--------------------
| 1  | data1| msg1 | 
--------------------
| 2  | data2| msg2 | 
--------------------
| 3  | data1| msg3 | 
--------------------
| 4  | data2| msg4 | 
--------------------
| 5  | data1| msg5 | 
--------------------

I have a php string $query = "select * from table WHERE col1='data1'"; , which fetch array 3 results (row number 1, 3, and 5). But i want to get a specific row containing "data1" in "col1" and "msg3" in "col2" (which is row number 3) in a single query. How can I make this possible?

moinudin · Accepted Answer · 2011-01-02 15:59:46Z

6

Use AND in the WHERE clause to match multiple conditions:

SELECT * FROM table WHERE col1='data1' AND col2='msg3'

answered Jan 2, 2011 at 15:59

moinudin

139k45 gold badges195 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

find row from mysql table with multiple parameters (from different columns) using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related