SQLize Online / PHPize Online  /  SQLtest Online

Create table `Customers` ( `cust_num` VARCHAR (3) NOT NULL , `cust_name` VARCHAR (20) NOT NULL , `cust_price` DOUBLE NOT NULL , `cust_id` VARCHAR (10) NOT NULL ); INSERT INTO `Customers` VALUES ("7", "JMUnion", 10, "1"), ("2", "Cucumber", 1000, "2"), ("3", "CornJo", 12, "3"), ("4", "Slave", 9999, "4"), ("1", "~pi", 3.49, "5") ; SELECT cust_name FROM `Customers` WHERE cust_name RLIKE "[JM%]"; Create table `Vendors` ( `vend_country` VARCHAR (10) NOT NULL , `vend_name` VARCHAR (20) NOT NULL , `vend_state` VARCHAR(15) NOT NULL , `cust_city` VARCHAR (10) NOT NULL ); INSERT INTO `Vendors` VALUES ("USA", "JMUnion", "10", "1"), ("SS", "Cucumber", "1000", "2"), ("USSR", "CornJo", "12", "3"), ("CHINA", "Slave", "9999", "4"), ("IRELAND", "~pi", "3.49", "5") ; SELECT vend_name || ' ' || vend_country FROM `Vendors` AS RESULT ORDER BY vend_name ASC; SELECT RTRIM(vend_name) || ' ' || RTRIM(vend_country) AS vend FROM Vendors ORDER BY vend_name ASC; SELECT RTRIM(vend_name) || ' ' || RTRIM(vend_country) AS vend FROM Vendors ORDER BY vend_name ASC;