How can I do boolean logic on two columns in MySQL?

Question

I want to do a select in MySql that combines several columns... something like this pseudocode:

SELECT payment1_paid AND payment2_paid AS paid_in_full 
FROM denormalized_payments 
WHERE payment1_type = 'check';

Edit: payment1_paid and payment2_paid are booleans.

I can't use any other language for this particular problem than MySql.

Thanks for any help!

Edit: Sorry to everybody who gave me suggestions for summing and concatenating, but I've voted those early answers up because they're useful anyway. And thanks to everybody for your incredibly quick answers!

Eric Hogue · Accepted Answer · 2008-10-29 22:50:55Z

5

Ok, for logical and you can do

Select (payment1_paid && payment2_paid) as paid_in_full 
from denormalized_payments 
where payment1_type = 'check';

As seen here.

answered Oct 29, 2008 at 22:50

Eric Hogue

8,9504 gold badges28 silver badges21 bronze badges

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

1 Comment

Dan Rosenstark Over a year ago

Excellent. That's what I needed, with the MySql reference to boot! Thank you.

Eric Hogue · Accepted Answer · 2008-10-29 22:42:06Z

2

Just do

Select CONCAT(payment1_paid, payment2_paid) as paid_in_full 
from denormalized_payments 
where payment1_type = 'check';

You can concat any number of field you want.

answered Oct 29, 2008 at 22:42

Eric Hogue

8,9504 gold badges28 silver badges21 bronze badges

Comments

Robert Gamble · Accepted Answer · 2008-10-29 22:53:10Z

2

If by combine you mean concatenate then this will work:

select concat(payment1_paid, payment2_paid) as paid_in_full
from denormalized_payments where payment1_type = 'check';

If by combine you mean add, then this should work:

select payment1_paid + payment2_paid as paid_in_full
from denormalized_payments where payment1_type = 'check';

[EDIT]

For boolean AND:

select payment1_paid && payment2_paid as paid_in_full
from denormalized_payments where payment1_type = 'check';

edited Oct 29, 2008 at 22:53

answered Oct 29, 2008 at 22:43

Robert Gamble

110k26 gold badges149 silver badges138 bronze badges

1 Comment

Dan Rosenstark Over a year ago

thanks, sorry the question was about booleans but that wasn't clear until later. great answer!

mohammedn · Accepted Answer · 2008-10-29 22:44:05Z

1

I am not sure but do you mean to concatenate?

SELECT CONCAT(ColumnA, ColumnB) AS ColumnZ
FROM Table

answered Oct 29, 2008 at 22:44

mohammedn

2,9703 gold badges23 silver badges30 bronze badges

Comments

Greg · Accepted Answer · 2008-10-29 22:46:51Z

1

SELECT IF(payment1_paid = 1 AND payment2_paid = 1, 1, 0) AS paid_in_fill

answered Oct 29, 2008 at 22:46

Greg

323k55 gold badges378 silver badges338 bronze badges

Comments

David Santamaria · Accepted Answer · 2008-10-29 22:48:58Z

0

If are Strings (or you want to treat like Strings the columns that you want to combine) you can use CONCAT and CONCAT_WS. Good luck!

answered Oct 29, 2008 at 22:48

David Santamaria

8,8318 gold badges36 silver badges43 bronze badges

Comments

dshaw · Accepted Answer · 2008-10-29 23:28:14Z

0

select (payment1_paid && payment2_paid) as paid_in_full
from denormalized_payments where payment1_type = 'check';

edited Oct 29, 2008 at 23:28

answered Oct 29, 2008 at 23:12

dshaw

2,1592 gold badges14 silver badges17 bronze badges

1 Comment

dshaw Over a year ago

Actually, It you should go with the Logical AND (&&) as @Robert Gamble mentioned since it should allow short circuit evaluation. Thus if payment1_paid is false, it's false. dev.mysql.com/doc/refman/5.0/en/…

Collectives™ on Stack Overflow

How can I do boolean logic on two columns in MySQL?

7 Answers 7

1 Comment

Comments

1 Comment

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

1 Comment

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related