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]
