Get count of how many times a string appears in a MySQL column?

Let us first create a table −

mysql> create table DemoTable704 (SubjectName text); Query OK, 0 rows affected (0.58 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable704 values('Introduction to MySQL'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable704 values('Introduction to MongoDB'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable704 values('Introduction to MySQL'); Query OK, 1 row affected (0.31 sec) mysql> insert into DemoTable704 values('Introduction to Java'); Query OK, 1 row affected (0.39 sec) mysql> insert into DemoTable704 values('Introduction to MongoDB'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable704 values('Introduction to MySQL'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable704 values('Introduction to C'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable704 values('Introduction to Spring and Hibernate'); Query OK, 1 row affected (0.12 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable704;

This will produce the following output -

+--------------------------------------+ | SubjectName                         | +--------------------------------------+ | Introduction to MySQL | | Introduction to MongoDB | | Introduction to MySQL | | Introduction to Java | | Introduction to MongoDB | | Introduction to MySQL | | Introduction to C | | Introduction to Spring and Hibernate | +--------------------------------------+ 8 rows in set (0.00 sec)

Following is the query to get count of how many times string appears in column −

mysql> SELECT COUNT(*) from DemoTable704 WHERE SubjectName LIKE '%Introduction to MySQL%';

This will produce the following output -

+----------+ | COUNT(*) | +----------+ | 3       | +----------+ 1 row in set (0.00 sec)