I have a database containing about 89758 record . Here is the example of the record . Structure CREATE TABLE IF NOT EXISTS `plants` ( `id` int(10) NOT NULL default '0', `symbol` varchar(255) NOT NULL default '', `scientific` varchar(255) NOT NULL default '', `common` varchar(255) NOT NULL default '', `family` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) Code (markup): INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae'); Code (markup): 1) I want to arrange the symbol in alphabetical order . 2) I want to populate / insert into wordpress database so that i can make a website PM Me with your offers. Pay You in paypal
SAMPLE SQL Table structure for table `plants` -- DROP TABLE IF EXISTS `plants`; CREATE TABLE IF NOT EXISTS `plants` ( `id` int(10) NOT NULL default '0', `symbol` varchar(255) NOT NULL default '', `scientific` varchar(255) NOT NULL default '', `common` varchar(255) NOT NULL default '', `family` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `plants` -- INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae'); INSERT INTO `plants` VALUES (2, 'ABGR4', 'Abelia ?grandiflora (Rovelli ex Andr?) Rehd. [chinensis ? uniflora]', 'glossy abelia', 'Caprifoliaceae'); INSERT INTO `plants` VALUES (3, 'ABELM', 'Abelmoschus Medik.', 'okra', 'Malvaceae'); INSERT INTO `plants` VALUES (4, 'ABES', 'Abelmoschus esculentus (L.) Moench', 'okra', 'Malvaceae'); INSERT INTO `plants` VALUES (5, 'HIES', 'Hibiscus esculentus L.', 'Abelmoschus esculentus', 'Malvaceae'); INSERT INTO `plants` VALUES (6, 'ABMA9', 'Abelmoschus manihot (L.) Medik. [excluded]', '', 'Malvaceae'); INSERT INTO `plants` VALUES (7, 'HIMA9', 'Hibiscus manihot L. [excluded]', 'Abelmoschus manihot', 'Malvaceae'); INSERT INTO `plants` VALUES (8, 'ABMO', 'Abelmoschus moschatus Medik.', 'musk okra', 'Malvaceae'); INSERT INTO `plants` VALUES (9, 'HIAB', 'Hibiscus abelmoschus L.', 'Abelmoschus moschatus', 'Malvaceae'); Code (markup):