How can I show all duplicate value from a specific column in MySQL

id name phone
1  google 5689
2  msn  63699
3  google 78972
4  yahoo  20144

I want to show the result like this

id name phone
1  google 5689
3  google 78972

Solution

select *
from ax
where name1 in (select name1 from ax group by name1 having count(name1)>1)

How/when mysql compiles stored procedures?
UPDATE column with Y or N if data exists in another table
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
How to get Python MYSQL connection username and password?
Table is marked as crashed and should be repaired
Coverting a .BAK file into a .SQL for use in XAMPP phpmyadmin
Query through JSON Array with multiple values in MySQL
Housing Society management system database structure
MySQL DROP all tables, ignoring foreign keys
When to use prepared statements?
When *not* to use prepared statements?
Are Prepared Statements a waste for normal queries? (PHP)
Deleting rows in mysql table that contain an empty field where more complete rows exist
MySQL given date between monday and sunday
JSON_TABLE - how to access fields inside escaped quotes?
mysqldump - maintain character set and collations
Why can't a text column have a default value in MySQL?
Using Hibernate's ScrollableResults to slowly read 90 million records
Foreign key in the child table is null after persisting @OneToMany
How to fix products without cover image in PrestaShop
Laravel Eloquent Query Using Case/When to apply conditions dynamically
MySQL SELECT a field as NULL if not existent in table
How can I show all duplicate value from a specific column in MySQL
Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handler declaration
PHP mySQL - Insert new record into table with auto-increment on primary key
IF ROW_COUNT() return error
Date column with associated MAX count value
Drop Column from Large Table
MySQL - 'Using index condition' vs 'Using where; Using index'
Conversion issues in sql - GREATEST(CEILING())