MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.36


CREATE TABLE Person (
    regno	varchar(12) not null primary key,
    fname	varchar(25),
    lname	varchar(25),
    dob	    date,
    sex	    varchar(1),
    phoneno	int,
    mailid	varchar(20),
    address	varchar(60),
    vid	    varchar(20)
);

INSERT INTO Person VALUES
("17291000456",	"Rahul",    "Kour",	    "2002-09-17",	"M",	8543210, "adsfasd@gmail.com",	    "Delhi-65",     "1111-2222-4444-7777"),
("17291500012",	"NP",       "Maji",	    "2002-09-14",	"F",	887652341,	"hfghj@rediffmail.com",	    "Delhi-65",	    "1111-2222-6666-4444"),
("17291900001",	"Suman",    "Baasu",	"2002-12-15",	"M",	987643210,	"m01@mail.com",	            "Kolkata-86",	"1111-2222-4444-3333"),
("17291900002",	"Jagannath","Baasu",	"1985-02-15",	"M",	987543210,	"jb@gmail.com",	            "Kolkata-86",	"1111-3333-2222-4444"),
("17292000003",	"Malati",   "Baasu",	"1977-02-10",	"F",	987133211,	"mb@outlook.com",	        "Kolkata-77",	"1111-2222-3333-4444"),
("17292000004",	"Hari",     "Baasu",	"2002-09-19",	"M",	887623210,	"kk@rediffmail.com",	    "Kolkata-65",	"3333-1111-2222-4444"),
("17292100005",	"Ambika",   "Kour",	    "2002-12-13",	"F",	887333210,	"kk1@gmail.com",	        "Delhi-65",	    "1111-2222-4444-5555"),
("17292100006",	"Akash",    "Maji",	    "2002-01-22",	"M",	887643210,	"addd@outlook.com",	        "Kolkata-66",	"1111-5555-2222-4444"),
("17292100007",	"Suresh",   "Baasu",	"2002-08-14",	"M",	887443210,	"adf45@outlook.com",	    "Kolkata-56",	"1111-2222-5555-4444"),
("17292100008",	"Rahul",    "Roy",      "2002-09-21",	"M",	887654210,	"hnfgh@rediffmail.com",	    "Kolkata-23",	"6666-1111-2222-4444"),
("17292100010",	"Susmita",  "Kour",	    "2002-05-18",	"F",	887003210,	"db124kk@gmail.com",	    "Mumbai-635",	"1111-6666-2222-4444"),
("17292200123",	"JP",       "Baasu",	"2002-08-11",	"M",	88653210, "adf@yahoo.com",	        "Mumbai-75",	"1111-7777-2222-4444"),
("17292431232",	"TK",       "Maji",	    "2002-02-16",	"F",	12345,   "ddde@mail.com",	        "Mumbai-625",	"1111-2222-7777-4444");

select fname as "Name start with 's'" 
    from Person where fname like 's%';

Records: 13  Duplicates: 0  Warnings: 0




Name start with 's'


Suman

Suresh

Susmita


set @st = "MYSQL ONLINE TUTORIAL";

select REGEXP_REPLACE(@st, 'online', '****', 1, 1, 'c') as 'Case Sensitive - (Not Matched)',
       REGEXP_REPLACE(@st, 'online', '****', 1, 1, 'i') as 'Case Insensitive - (Matched)';


Case Sensitive - (Not Matched)
Case Insensitive - (Matched)


MYSQL ONLINE TUTORIAL
MYSQL **** TUTORIAL