if (stop < start, stop, CONCAT(stop, '+++'))
should do the trick.
- Rich
hello dear all,
i need to make a select on mysql with IF funcion:
if ('stop' <'start', stop, '+++')
where start and stop are timestamps. and [+++] is an error char.
Actually my select result are:
+----------+--------+ | data | start | stop | +----------+-------+--------+ | 20030301 | 74621 | +++ | | 20030302 | 74840 | 181211 |
but i have a question:
Is possible, and if yes how, to make so that query generate a result like:
+----------+--------+ | data | start | stop | +----------+-------+--------+ | 20030301 | 74621 |0020 +++ | | 20030302 | 74840 | 181211 |
where: if the stop time is < (less than) start time i can print stop time and error char together.
Thanks in advance !
fabrizio
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]