| Ayuda ordenar abse de datos sql
Hola tengo esta base de datos:
y necesito ordenar lar marcas alfabeticamente como lo ago?
-- phpMyAdmin SQL Dump
-- version 2.11.9.1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 23-10-2008 a las 01:09:00
-- Versión del servidor: 5.0.51
-- Versión de PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de datos: `autosenc_autosenchile`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `jos_autoexp_model`
--
CREATE TABLE IF NOT EXISTS `jos_autoexp_model` (
`id` int(11) NOT NULL auto_increment,
`mark_id` int(11) default NULL,
`name` varchar(20) default '',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1076 ;
--
-- Volcar la base de datos para la tabla `jos_autoexp_model`
--
INSERT INTO `jos_autoexp_model` (`id`, `mark_id`, `name`, `published`) VALUES
(1, 1, 'CL', 1),
(2, 1, 'EL', 1),
(3, 1, 'Integra', 1),
(4, 1, 'MDX', 1),
(5, 1, 'NSX', 1),
(6, 1, 'RL', 1),
(7, 1, 'RSX', 1),
(8, 1, 'SLX', 1),
(9, 1, 'TL', 1),
(10, 1, 'TSX', 1),
(11, 1, 'Vigor', 1),
(12, 2, 'DB7', 1),
(13, 2, 'DB9', 1),
(14, 2, 'Lagonda', 1),
(15, 2, 'Vanquish', 1),
(16, 2, 'Vantage', 1),
(17, 2, 'Virage', 1),
(18, 2, 'Volante', 1),
(19, 2, 'Zagato', 1),
(20, 3, '100', 1),
(21, 3, '200', 1),
(22, 3, '80', 1),
(23, 3, '90', 1),
(24, 3, 'A2', 1),
(25, 3, 'A3', 1),
(26, 3, 'A4', 1),
(27, 3, 'A6', 1),
(28, 3, 'A8', 1),
(29, 3, 'Allroad', 1),
(30, 3, 'B4', 1),
(31, 3, 'Cabriolet', 1),
(32, 3, 'Coupe', 1),
(33, 3, 'Q7', 1),
(34, 3, 'Quattro', 1),
(35, 3, 'RS 2', 1),
(36, 3, 'RS 4', 1),
(37, 3, 'RS 6', 1),
(38, 3, 'S2', 1),
(39, 3, 'S3', 1),
(40, 3, 'S4', 1),
(41, 3, 'S6', 1),
(42, 3, 'S8', 1),
(43, 3, 'TT', 1),
(44, 3, 'V8', 1),
(45, 4, 'Arnage', 1),
(46, 4, 'Azure', 1),
(47, 4, 'Brooklands', 1),
(48, 4, 'Continental', 1),
(49, 5, '1 class', 1),
(50, 5, '3 class', 1),
(51, 5, '5 class', 1),
(52, 5, '6 class', 1),
(53, 5, '7 class', 1),
(54, 5, '8 class', 1),
(55, 5, 'Alpina', 1),
(56, 5, 'M Coupe', 1),
(57, 5, 'M Roadster', 1),
(58, 5, 'M3', 1),
(59, 5, 'M5', 1),
(60, 5, 'X3', 1),
(61, 5, 'X5', 1),
(62, 5, 'Z1', 1),
(63, 5, 'Z3', 1),
(64, 5, 'Z4', 1),
(65, 5, 'Z8', 1),
(66, 6, 'Century', 1),
(67, 6, 'Electra', 1),
(68, 6, 'LeSabre', 1),
(69, 6, 'Park Avenue', 1),
(70, 6, 'Rainer', 1),
(71, 6, 'Regal', 1),
(72, 6, 'Rendezvous', 1),
(73, 6, 'Riviera', 1),
(74, 6, 'Roadmaster', 1),
(75, 6, 'Skylark', 1),
(76, 7, 'Allante', 1),
(77, 7, 'Catera', 1),
(78, 7, 'CTS', 1),
(79, 7, 'DeVille', 1),
(80, 7, 'Eldorado', 1),
(81, 7, 'Escalade', 1),
(82, 7, 'Fleetwood', 1),
(83, 7, 'LSE', 1),
(84, 7, 'Seville', 1),
(85, 7, 'SRX', 1),
(86, 7, 'Vizon', 1),
(87, 7, 'XLR', 1),
(88, 8, 'Alero', 1),
(89, 8, 'Astro', 1),
(90, 8, 'Avalanche', 1),
(91, 8, 'Beretta', 1),
(92, 8, 'Blazer', 1),
(93, 8, 'Camaro', 1),
(94, 8, 'Caprice', 1),
(95, 8, 'Cavalier', 1),
(96, 8, 'Celta', 1),
(97, 8, 'Chevy Van', 1),
(98, 8, 'Colorado', 1),
(99, 8, 'Corsica', 1),
(100, 8, 'Corvette', 1),
(101, 8, 'Equinox', 1),
(102, 8, 'Express', 1),
(103, 8, 'Impala', 1),
(104, 8, 'Ipanema', 1),
(105, 8, 'Kalos', 1),
(106, 8, 'Lumina', 1),
(107, 8, 'Malibu', 1),
(108, 8, 'Matiz', 1),
(109, 8, 'Metro', 1),
(110, 8, 'Monte Carlo', 1),
(111, 8, 'Monza', 1),
(112, 8, 'Nubira', 1),
(113, 8, 'Prizm', 1),
(114, 8, 'S-10', 1),
(115, 8, 'Silverado', 1),
(116, 8, 'Spark', 1),
(117, 8, 'SSR', 1),
(118, 8, 'Suburban', 1),
(119, 8, 'Tahoe', 1),
(120, 8, 'Tracker', 1),
(121, 8, 'Trail Blazer', 1),
(122, 8, 'Trans Sport', 1),
(123, 8, 'Venture', 1),
(124, 9, '300M', 1),
(125, 9, '300C', 1),
(126, 9, 'Cirrus', 1),
(127, 9, 'Concorde', 1),
(128, 9, 'Crossfire', 1),
(129, 9, 'Daytona Shelby', 1),
(130, 9, 'Grand Voyager', 1),
(131, 9, 'Intrepid', 1),
(132, 9, 'Jeep Grande Cherokee', 1),
(133, 9, 'Jeep Cherokee', 1),
(134, 9, 'Le Baron', 1),
(135, 9, 'LHS', 1),
(136, 9, 'Neon', 1),
(137, 9, 'New Yorker', 1),
(138, 9, 'Pacifica', 1),
(139, 9, 'Prowler', 1),
(140, 9, 'PT Cruiser', 1),
(141, 9, 'Saratoga', 1),
(142, 9, 'Sebring', 1),
(143, 9, 'Stratus', 1),
(144, 9, 'Town & Country', 1),
(145, 9, 'Viper', 1),
(146, 9, 'Vision', 1),
(147, 9, 'Voyager', 1),
(148, 48, 'AX', 1),
(149, 48, 'Berlingo', 1),
(150, 48, 'BX', 1),
(151, 48, 'C15', 1),
(152, 48, 'C2', 1),
(153, 48, 'C25', 1),
(154, 48, 'C3', 1),
(155, 48, 'C4', 1),
(156, 48, 'C5', 1),
(157, 48, 'C8', 1),
(158, 48, 'CX', 1),
(159, 48, 'Evasion', 1),
(160, 48, 'Jumper', 1),
(161, 48, 'Jumpy', 1),
(162, 48, 'Saxo', 1),
(163, 48, 'Synergie', 1),
(164, 48, 'Visa', 1),
(165, 48, 'Xantia', 1),
(166, 48, 'XM', 1),
(167, 48, 'Xsara', 1),
(168, 48, 'Xsara Pacasso', 1),
(169, 48, 'ZX', 1),
(170, 10, 'Aranos', 1),
(171, 10, 'Arcadia', 1),
(172, 10, 'Brougham', 1),
(173, 10, 'Chairman', 1),
(174, 10, 'Cielo', 1),
(175, 10, 'Damas', 1),
(176, 10, 'Espero', 1),
(177, 10, 'Evanda', 1),
(178, 10, 'Istana', 1),
(179, 10, 'Kalos', 1),
(180, 10, 'Korando', 1),
(181, 10, 'Labo', 1),
(182, 10, 'Lacetti', 1),
(183, 10, 'Lanos', 1),
(184, 10, 'Leganza', 1),
(185, 10, 'Lublin', 1),
(186, 10, 'Magnus', 1),
(187, 10, 'Matiz', 1),
(188, 10, 'Musso', 1),
(189, 10, 'Nexia', 1),
(190, 10, 'Nubira', 1),
(191, 10, 'Polonez', 1),
(192, 10, 'Prince', 1),
(193, 10, 'Racer', 1),
(194, 10, 'Rexton', 1),
(195, 10, 'Rezzo', 1),
(196, 10, 'Tacuma', 1),
(197, 10, 'Tico', 1),
(198, 11, 'Avenger', 1),
(199, 11, 'Caravan', 1),
(200, 11, 'Charger', 1),
(201, 11, 'Dakota', 1),
(202, 11, 'Durango', 1),
(203, 11, 'Grand Caravan', 1),
(204, 11, 'Intrepid', 1),
(205, 11, 'Magnum', 1),
(206, 11, 'Neon', 1),
(207, 11, 'Ram', 1),
(208, 11, 'Spirit', 1),
(209, 11, 'Stealth', 1),
(210, 11, 'Stratus', 1),
(211, 11, 'Viper', 1),
(212, 11, 'Voyager', 1),
(213, 12, 'Summit', 1),
(214, 12, 'Summit Wagon', 1),
(215, 12, 'Talon', 1),
(216, 12, 'Vision', 1),
(217, 13, '360 Modena', 1),
(218, 13, '456', 1),
(219, 13, '550', 1),
(220, 13, '575', 1),
(221, 13, '612', 1), |