Can we write sql query in mysql custum function -

can write mysql query in custom function of mysql

please take in example

// here **price** input parameter   begin   declare profit decimal(9,2);   set  =  select count(*) users; // let output 5    set profit = price-all ;   return profit; end 

off course can do. create function correctly , call these function called user defined functions

sqlfiddle working demo. sqlfiddle not executing select query. test like

code:

   create function calc(price float)  returns float    begin       declare profit float;       declare varallr int;       set varallr = (select count(*) users);       set profit = price-varallr ;       return profit;    end 

remember need use // delimiter.

   select calc(5); //gives 3