MySQL Forums
Forum List  »  German

compare binary values
Posted by: Simon Oberländer
Date: October 15, 2014 11:59PM

Hey there,

I have the following problem:
I represent three checkboxes, which queries a filter for MySQL. How do I check in MySQL if the record meets the requirements?

As an example:
Checkbox 1 & 3 are active => 101 (binary) => 5 (decimal)
Record 1: 4 (decimal) => 100 (binary) => Invalid
Record 2: 7 (decimal) => 111 (binary) => valid

It is posible, or must i check in PHP if the value of the checkbox is in the value of the database?

Looking for help :)

Simon

Options: ReplyQuote


Subject
Views
Written By
Posted
compare binary values
2265
October 15, 2014 11:59PM
1130
October 16, 2014 01:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.