#SELECT SUBSTRING ('HELL BUDDY', 1, 4);  # IT WILL THORW ERROR SUBSTRING AND BRACKET HAVE SPACE BETWEEN
#SUBSTRING: Extracts part of a string
SELECT SUBSTRING('HELL BUDDY', 1, 4);
SELECT SUBSTRING('HELL BUDDY',5, 4);
SELECT SUBSTRING('HELL BUDDY',4);
SELECT SUBSTRING('HELL BUDDY, WASSUP RAJU',-4);

#replace hey ---> hello
#REPLACE (str,from_str,to_str)
SELECT REPLACE('JAI HIND', 'JAI','JAWAN');

CREATE table employees(
    emp_id INT  PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(50) NOT NULL,
    lname VARCHAR(50) NOT NULL,
    desig VARCHAR(50) NOT NULL DEFAULT 'Probation',
    dept VARCHAR(50) NOT NULL
);
INSERT into employees (emp_id,fname,lname,desig,dept) VALUES (101,'RAJU','DWIVEDI','Manager','Loan');
INSERT into employees (fname,lname,desig,dept) VALUES ('SHAM','SUNDAR','CASHIER','CASH');
INSERT into employees (fname,lname,desig,dept) VALUES ('PAUL','TIWARI','ASSOCIATE','LOAN');
INSERT into employees (fname,lname,desig,dept) VALUES ('ALEX','MISHRA','ACCOUNTANT','LOAN');
INSERT into employees (fname,lname,desig,dept) VALUES ('VICTOR','TRIPATHI','ASSOCIATE','DEPOSIT');
#SELECT * FROm employees;
SELECT SUBSTRING(emp_id,2) AS emp_id, fname from employees;
#REPLACE REPLACE: Replaces part of a string with another string.
SELECT REPLACE(emp_id,10,10000) AS NewEMPsID, fname from employees;
SELECT REPLACE(emp_id,10,'EMP') AS IDs, fname from employees;