Mysql: How to know wich condition failed in a query
Posted: Wed Jan 09, 2008 12:34 pm
Hi All
Is there a way to know wich condition failed within a query?
ie in SELECT name, last_name where last_name = ´fox´ and sex = ´every day´;
If the query returns no value, I´ll like to know wich, or all, of the conditions failed.
I do workarroud this by cascading multiples queries but this isn´t an optimized way to do it.
Regards,
Alvaro
Is there a way to know wich condition failed within a query?
ie in SELECT name, last_name where last_name = ´fox´ and sex = ´every day´;
If the query returns no value, I´ll like to know wich, or all, of the conditions failed.
I do workarroud this by cascading multiples queries but this isn´t an optimized way to do it.
Regards,
Alvaro