[thelist] MySQl madness

Tony Crockford tonyc at boldfish.co.uk
Tue Dec 9 16:11:29 CST 2003


Maybe it's my choice of music or maybe it's just old age but how can the 
following list be ordered by cd_title?

   	cd_ref 	cd_title  			cd_desc 	
   	 	5	Used Unrestored		good used condition fully working	
   	 	2	A1 Restored		Perfect restored Condition	
   	 	1	A1 Unrestored		Perfect unrestored Condition	
   	 	4	Pattern only		Very poor condition to be used onlt for patterm ma...	
   	 	3	Urgent action		Poor Condition. Preservation required to prevent l...


This is the mySQL query:

SELECT * FROM cond_def ORDER BY cd_title

How can U come before A?

what am I not seeing?

help me folks ;o)

TIA

Tony


-- 
   listening to: fame academy - perfect

    http://www.xebit.net


More information about the thelist mailing list