Select only the fractional part of the value of the number

Question

How to select only part of the value of the number to the right of the decimal point?

So for example:

SELECT ____(10.1234) AS mynumber; 

Where is the result:

 .1234 (or 1234) 

Answer 1

The MOD> function should work:

 SELECT MOD(10.1234, 1); -- -> 0.1234 

Answer 2

Just subtract the integer part:

 select mynumber - truncate(mynumber,0) from mytable; 

Answer 3

You can also use below ...

 select substring_index(field1,'.',1), substring_index(field1,'.',-1) from table1; 

Output example

 mysql> select substring_index(120.45,'.',1), substring_index(120.45,'.',-1) ; +-------------------------------+--------------------------------+ | substring_index(120.45,'.',1) | substring_index(120.45,'.',-1) | +-------------------------------+--------------------------------+ | 120 | 45 | +-------------------------------+--------------------------------+ 1 row in set (0.00 sec)