I am using MySql and one of my tables, User_tb, has a column, user_email, where I store users' email addresses. I am relatively new to SQL, but I need to insert 'Sponsored' before the @ from the email address.
Example, email@example.com => dummyuserSponsored@gmail.com .
All my research points me to using substr however I am not exactly sure how to actually executed on it. Any help is appreciated :)
update User_tb set user_email = replace(user_email, '@', 'Sponsored@')