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",	"Rahu&l",    "Kour",	    "2002-09-17",	"M",	8543210, "adsfasd@gmail.com",	    "Delhi-65",     "1111-2222-4444-7777"),
("17291500012",	"N$P",       "Maji",	    "2002-09-14",	"F",	887652341,	"hfghj@rediffmail.com",	    "Delhi-65",	    "1111-2222-6666-4444"),
("17291900001",	"Sum&an",    "Baasu",	"2002-12-15",	"M",	987643210,	"m01@mail.com",	            "Kolkata-86",	"1111-2222-4444-3333"),
("17291900002",	"Jaga$nnath","Baasu",	"1985-02-15",	"M",	987543210,	"jb@gmail.com",	            "Kolkata-86",	"1111-3333-2222-4444"),
("17292000003",	"",   "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",	"",       "Maji",	    "2002-02-16",	"F",	12345,   "ddde@mail.com",	        "Mumbai-625",	"1111-2222-7777-4444");

select * from Person;

Records: 13  Duplicates: 0  Warnings: 0




regno
fname
lname
dob
sex
phoneno
mailid
address
vid


17291000456
Rahu&l
Kour
2002-09-17
M
8543210
adsfasd@gmail.com
Delhi-65
1111-2222-4444-7777

17291500012
N$P
Maji
2002-09-14
F
887652341
hfghj@rediffmail.com
Delhi-65
1111-2222-6666-4444

17291900001
Sum&an
Baasu
2002-12-15
M
987643210
m01@mail.com
Kolkata-86
1111-2222-4444-3333

17291900002
Jaga$nnath
Baasu
1985-02-15
M
987543210
jb@gmail.com
Kolkata-86
1111-3333-2222-4444

17292000003

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

Maji
2002-02-16
F
12345
ddde@mail.com
Mumbai-625
1111-2222-7777-4444


SELECT fname FROM Person WHERE fname LIKE '%&%';


fname


Rahu&l

Sum&an

Hari&

$Ambika&

&Rahul$

Susmita&


SELECT fname FROM Person WHERE fname LIKE '%$%';


fname


N$P

Jaga$nnath

$Ambika&

Suresh$

&Rahul$

regno	fname	lname	dob	sex	phoneno	mailid	address	vid
17291000456	Rahu&l	Kour	2002-09-17	M	8543210	adsfasd@gmail.com	Delhi-65	1111-2222-4444-7777
17291500012	N$P	Maji	2002-09-14	F	887652341	hfghj@rediffmail.com	Delhi-65	1111-2222-6666-4444
17291900001	Sum&an	Baasu	2002-12-15	M	987643210	m01@mail.com	Kolkata-86	1111-2222-4444-3333
17291900002	Jaga$nnath	Baasu	1985-02-15	M	987543210	jb@gmail.com	Kolkata-86	1111-3333-2222-4444
17292000003		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		Maji	2002-02-16	F	12345	ddde@mail.com	Mumbai-625	1111-2222-7777-4444