create a function use in MySQL?

I want to create a function
it do some calculate and return one
row of records;
now I want to use it like:
"select MyFuction(a,b) from tbl" just like "select MAX() from tbl"
How can I do it?
give me the important souce code please
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I don't know much about MySQL, but there is some good looking doc. at
MySQL does not support stored functions and procedures. You will not be able to achieve what you're looking for server-side, and instead will have to look at how to get the functionality from whatever environment interacts with MySQL. Obviously you can code functions in perl, C++, PHP, etc that would do what you want. These functions could interact with the data on the MySQL database and return the result you require. This is discussed in the MySQL reference manual in the "Functionality missing from MySQL" section:

If you are doing this from a web server I would recommend that you look at PHP ( It has excellent integration with MySQL for doing programmatic manipulation of data as functions similar to what you describe.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux OS Dev

From novice to tech pro — start learning today.