@@taniyasaini6830 There you go: SELECT *, replace(dept_name,'Analytics','Data Science') as r_dept_name, insert(dept_name,1,3,'Demo') as stuff_string, substring(dept_name,1,4) as subs_dept_name, replace(replace(dept_name,'A','S'),'T','R') as t_dept_name FROM ankit_sql.dept;
I am gonna finish all your videos in 2 days.I am revising for ba/da role
Very useful and handy sometimes ! Thank you ..
Thnks for the video!
Welcome
Great
Thank you 😊
does stuff() function not exist in Postgres?
Are these applicable on MySQL? Can you post the MySQL version of these functions
For Stuff and translate i couldnt find any equivalent in MySQL
@@taniyasaini6830 There you go:
SELECT
*,
replace(dept_name,'Analytics','Data Science') as r_dept_name,
insert(dept_name,1,3,'Demo') as stuff_string,
substring(dept_name,1,4) as subs_dept_name,
replace(replace(dept_name,'A','S'),'T','R') as t_dept_name
FROM
ankit_sql.dept;
Increase font size then it's better for us
Sure