mysql Short 2

SQL 467

SELECT id,
ven,
CONCAT( ven, IF( RIGHT(ven,1) REGEXP ('^[0-9]'),'0', '' ) ) AS vif,
CONCAT( REPEAT( 0, 6 - LENGTH((SELECT vif))), (SELECT vif) ) AS ved
FROM den ORDER BY ved ASC ;
CREATE TABLE `den` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`ven` VARCHAR(45) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ven_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `den` VALUES (1,'1a'),(2,'1b'),(3,'2a'),(4,'2b'),(5,'2c'),(6,'14a'),(7,'14c'),(8,'20');

Recent Pastes