MySQL-এ কলামে নির্দিষ্ট শব্দের повторাবৃত্তির সংখ্যা জানা

এজন্য COUNT() ফাংশন ব্যবহার করুন।

টেবিল তৈরি করা

mysql> create table DemoTable 
-> ( 
-> EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, 
-> EmployeeName varchar(100) 
-> ); 
Query OK, 0 rows affected (0.62 sec)

রেকর্ড ইনসার্ট করা

mysql> insert into DemoTable(EmployeeName) values('John'); 
Query OK, 1 row affected (0.21 sec) 
mysql> insert into DemoTable(EmployeeName) values('Carol'); 
Query OK, 1 row affected (0.17 sec) 
mysql> insert into DemoTable(EmployeeName) values('David'); 
Query OK, 1 row affected (0.14 sec) 
mysql> insert into DemoTable(EmployeeName) values('Carol'); 
Query OK, 1 row affected (0.14 sec) 
mysql> insert into DemoTable(EmployeeName) values('Carol'); 
Query OK, 1 row affected (0.29 sec) 
mysql> insert into DemoTable(EmployeeName) values('Bob'); 
Query OK, 1 row affected (0.22 sec) 
mysql> insert into DemoTable(EmployeeName) values('Sam'); 
Query OK, 1 row affected (0.12 sec)

সকল রেকর্ড প্রদর্শন

mysql> select *from DemoTable;

আউটপুট

+------------+--------------+ 
| EmployeeId | EmployeeName | 
+------------+--------------+ 
| 1          | John         | 
| 2          | Carol        | 
| 3          | David        | 
| 4          | Carol        | 
| 5          | Carol        | 
| 6          | Bob          | 
| 7          | Sam          | 
+------------+--------------+ 
7 rows in set (0.00 sec)

নির্দিষ্ট শব্দ (Carol) এর পুনরাবৃত্তি গণনার কোয়েরি

mysql> select EmployeeName,count(EmployeeId) as Occurrence from DemoTable where EmployeeName='Carol';

আউটপুট

+--------------+------------+ 
| EmployeeName | Occurrence | 
+--------------+------------+ 
| Carol        | 3          | 
+--------------+------------+ 
1 row in set (0.05 sec)