How would I construct a mysql query to use multiple AND operators?

Question

eg "SELECT * FROM date WHERE name = 'etc' AND lastname = 'etc' AND etc='etc'";

Question is not clear. You have already constructed a query. — zerkms
– zerkms, Commented Apr 16, 2011 at 15:31
I'm assuming you mean, How would I construct a mysql query to use multiple AND operators using a language other than SQL. If that is what you mean, better say so... — razlebe
– razlebe, Commented Apr 16, 2011 at 15:36

crimson_penguin · Accepted Answer · 2011-04-16 15:32:16Z

8

You do it exactly like you just said.

answered Apr 16, 2011 at 15:32

crimson_penguin

2,7781 gold badge17 silver badges24 bronze badges

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

Comments

Shakti Singh · Accepted Answer · 2011-04-16 15:38:51Z

2

Assuming you are talking to construct query based on PHP input variables

$fields = array( "name", "lastname", "etc" ) ;
foreach( $fields as $field)
{
   $clause[]=$field."='".mysql_real_escape_string($_POST[$field])."'";
}
$query = "SELECT * from `date` where "
         .implode( " AND ", $clause );

answered Apr 16, 2011 at 15:38

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Comments

Bastardo · Accepted Answer · 2011-04-16 15:39:32Z

0

you'll do it like this

eg "SELECT * FROM date WHERE name = 'etc' AND lastname = 'etc' AND etc='etc'";

answered Apr 16, 2011 at 15:39

Bastardo

4,1529 gold badges43 silver badges60 bronze badges

Collectives™ on Stack Overflow

How would I construct a mysql query to use multiple AND operators?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related