I have a query like this:
select c.order_id,sum(c.final_for_referraler) as sum,u.email
from exchaino_app.commissions as c
left join exchaino_app.orders as o on c.order_id = o.id
left join exchaino_app.users as u on c.order_user_id = u.id
group by c.order_id,c.order_user_id;
It returns an answer like this :
order_id sum email
1 10 john@gmail.com
2 11 johnesmit@gmail.com
I want to replace the email address with some *
it should be return like this:
jo**@gmail.com
jo******@gmail.com
in query or laravel side without foreach.