MYSQL Tutorial

MySQL EXPORT_SET() function

EXPORT_SET() function

Here is how MySQL EXPORT_SET() works -

1. For every bit of the first argument (which is supplied as an integer but the function works by converting it into bits) it checks whether it is 1 or 0. The order of checking is right to left.

2. If the bit is 1, it returns the second argument.

3. If the bit is 0, it returns the third argument.

4. While displaying, it places a separator (which is the fourth argument) between the return values. And return values are displayed from left to right.

5. The checking continues upto the number of bits specified in the last, i.e. fifth argument. The default value of the fifth argument is 64.


EXPORT_SET(bits, on, off, [separator [, number of bits]]) 


Name Description
Bits (got by converting the supplied integer to bits) which are to be compared if they 1 or 0.
on If the bit in the first argument is 1, this is returned.
off If the bit in the second argument is 0, this is returned.
separator To be placed between the return values while displaying the output.
number of bits How many bits are to be compared if they are 1 or 0 of the first argument (i.e. bits).

MySQL Version: 5.6

Video Presentation

Example : MySQL EXPORT_SET() function

The following MySQL statement returns Y,N,Y. See the explanation -


SELECT EXPORT_SET(5,'Y','N',',',3); 


1. If converted, the first argument 5 stands for 00000101.

2. Now, taking one bit at a time from the right, first bit is 1, so it returns the second argument Y. For the third bit, it returns Y. For all the remaining bits, it returns N.

3. The fourth argument "," as taken as a separator for while displaying the returned bits.

4. While displaying bits returned from left tot right, so the out is Y,N,Y.

Sample Output:

mysql> SELECT EXPORT_SET(5,'Y','N',',',3);
| EXPORT_SET(5,'Y','N',',',3) |
| Y,N,Y                       | 
1 row in set (0.00 sec)


The following MySQL statement returns 0,0,1,0,0,0,0,0 after performing a EXPORT_SET operation on the given arguments.


SELECT EXPORT_SET(4,'1','0',',',8); 

Sample Output:

mysql> SELECT EXPORT_SET(4,'1','0',',',8);
| EXPORT_SET(4,'1','0',',',8) |
| 0,0,1,0,0,0,0,0             | 
1 row in set (0.00 sec)

All String Functions

MySQL String Functions, slide presentation

Many of our valued users post comments along with piece of code. Disqus may, false positively, consider those piece of code as Bad or Starnge syntax and send those comments to spam automatically. Even if that happens, we will make sure those useful comments are taken out of spam and approved. It may take a couple of days for that though, but any useful comment will be brought to public view for sure. We regret if that happend to any user. You may write us directly regarding this to - w3resource[at]yahoo[dot]com.