Php bitcount implemantation errors

Question

Suppose you have two binary values:

001011 and 001111

How can you get the number of different bits in MySQL? I tried:

SELECT BIT_COUNT(BINARY  001011 ^ BINARY 001111)

This returns 6.I mean how to implement it? I means either i need from fetching mysql query or from php script?Please help.

ok,for example you have two no. 95750 and 74898.We have to count different bits in this,function for that is SELECT BIT_COUNT(BINARY 74898 ^ BINARY 95750).Now how to implement it.I short suppose bitcount no. of above query is 6.Then it is not dsiplaying 6. — , Aug 22 '14 at 07:28
I is Mysql query,if you are having extra solution please provide.@http://stackoverflow.com/users/608639/jww — , Aug 22 '14 at 12:47

score 0 · Answer 1 · answered Aug 22 '14 at 08:11

0

perform sql operation with query

SELECT BIT_COUNT(BINARY  001011 ^ BINARY 001111) as bitcount

then print the result,say $result['bitcount']

answered Aug 22 '14 at 08:11

arunrc

It says Parse error: syntax error, unexpected 'BIT_COUNT' (T_STRING) in C:\xampp\htdocs\script.php on line 4.But never mind,i have found a alternate solution for this.Thanx. – Aug 22 '14 at 08:29
Good to hear that:) Please put the solution here, so that it will be helpful for others. – arunrc Aug 22 '14 at 08:58

score -1 · Answer 2 · answered Aug 22 '14 at 06:56

-1

Answer is strlen

$bit = "001011";
$count = strlen($bit);
echo $count;

OUTPUT : 6

answered Aug 22 '14 at 06:56

Satish Sharma

1

It is ok,but how to compare both as 001011 ^ BINARY 001111 of different bit in both??? – Aug 22 '14 at 06:59

2 Answers2