MySQL function pass a parameter from query

Question

I have a function that will take a user's id as a parameter and do stuff using that parameter. I would like to call that function for several users.

For a single user I successfully use:

SELECT myFuncFoo(1);

And for multiple users I tried this without luck:

SELECT users.id as uid, 
(SELECT myFuncFoo(uid))
FROM users;

I also tried without aliases:

SELECT users.id,
(SELECT myFuncFoo(users.id))
FROM users;

How can I achieve this?

vhu · Accepted Answer · 2015-10-26 08:38:57Z

5

Use the following if you want to execute myFuncFoo() for every row:

SELECT users.id,
myFuncFoo(users.id)
FROM users;

answered Oct 26, 2015 at 8:38

vhu

12.9k11 gold badges42 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abhinav Singh Maurya · Accepted Answer · 2015-10-26 08:52:34Z

1

select myFuncFoo(uid) from(select uid from users where uid=1);

3,3238 gold badges35 silver badges51 bronze badges

answered Oct 26, 2015 at 8:33

sreenivas

214 bronze badges

Please explain your answer.

select uid,myFunFoo(uid) from users