SQL/MySQL/Math/LOG

Use log

   <source lang="sql">

/* mysql> select LOG(20); +----------------+ | LOG(20) | +----------------+ | 2.995732273554 | +----------------+ 1 row in set (0.00 sec) mysql> select LOG(20, 40); +-----------------+ | LOG(20, 40) | +-----------------+ | 1.2313782131598 | +-----------------+ 1 row in set (0.01 sec)

• /

select LOG(20); select LOG(20, 40);

      </source>
   
  

Use LOG10 and LOG2

   <source lang="sql">

/* mysql> select LOG10(10); +-----------+ | LOG10(10) | +-----------+ | 1 | +-----------+ 1 row in set (0.00 sec) mysql> select LOG2(8); +---------+ | LOG2(8) | +---------+ | 3 | +---------+ 1 row in set (0.00 sec)

• /

select LOG10(10); select LOG2(8);

      </source>