Reply
Highlighted
Member
Posts: 1
Registered: ‎12-13-2019

COUNT request or help with figuring out how many, if or else Mysql.

Good morning!,

Trying to find how many times a record is presented within a set amount of data with the following conditions

if the record has a 1 in a certain field for all records matching a certain condition then Y

If the record has a 0 in a certain field for all records matching a certain condition then N

If the record has SOME 1,0s in a certain field for all records matching a certain condition then B

the condition matching is primary key in that table via JOIN.. I was thinking I could count the field and then count the instances of the record and do some math to figure out if both = then Y, if < B and if NOT then N..

 

Thanks

Highlighted
New Member
Posts: 13
Registered: ‎02-12-2020

Re: COUNT request or help with figuring out how many, if or else Mysql.

Highlighted
New Member
Posts: 1
Registered: ‎02-14-2020

Re: COUNT request or help with figuring out how many, if or else Mysql.

mysql solves the problem in the data hidow xpd 12 review

Highlighted
New Member
Posts: 1
Registered: ‎02-17-2020

Re: COUNT request or help with figuring out how many, if or else Mysql.

This is awesome I like it this is helpful for us.

 

Cyberflix APK, Mediabox, Catmouse, UnlockMyTV, NewestMoviesHD