MySQL Forums
Forum List  »  Optimizer & Parser

Functions in the where clause
Posted by: John Dzilvelis
Date: May 21, 2007 10:26AM

Does a function in the where clause of a select statement get executed individually for each row of the result set?

For example :

-- select new customers:
select Customer_id,Customer_name , start_date
from customers
where start_date > date_sub("2007-04-30", interval 12 month) ;

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Functions in the where clause
4128
May 21, 2007 10:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.