> 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
What about an ORDER BY with a CASE statement that uses
the CreationDate if ModifyDate = 0 and ModifyDate if it's <> 0.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL