FIND_IN_SET :
This is the function used in mysql to seperate comma from a string.
string _emp_id ="1,2,3,5"
in the procedure use
find_in_set(emp_id,_emp_id);
so here it automatically seperate the _emp_id , first it will take 1 , then 2 ,3, 4 and 5 and do the operation.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|