Hello, > I have two date fields (1095689105) in mysql. One is Creation date and > other is Modify date. If news is not modified its value is 0. How can I > sort my news so modify date is more important (if exists) than creation > date?
What about an ORDER BY with a CASE statement that uses the CreationDate if ModifyDate = 0 and ModifyDate if it's <> 0. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
