TEXT 33
Mysql Short 3 By Guest on 27th April 2017 08:45:51 AM
  1. SELECT id,
  2.       ven,
  3.       CONCAT( ven, IF( RIGHT(ven,1) REGEXP ('^[0-9]'),'0', '' ) )  AS vif,
  4.       CONCAT( REPEAT( 0, 6 - LENGTH((SELECT vif))), (SELECT vif) ) AS ved
  5. FROM den
  6.  
  7.  HAVING ved > '00002b'
  8.  
  9. ORDER BY ved ASC ;

Paste is for source code and general debugging text.

Login or Register to delete or keep track of your pastes.