How will Show all records containing the name “sonia” AND the phone number ‘9876543210’
mysql> SELECT * FROM tablename WHERE name = “sonia” AND phone_number = ‘9876543210’
To retrieve records containing the name “sonia” and the phone number ‘9876543210’ in MySQL, you can use the SELECT statement with the WHERE clause. Here’s an example query:
sql
SELECT * FROM your_table_name
WHERE name = 'sonia' AND phone_number = '9876543210';
Make sure to replace your_table_name with the actual name of your table where the data is stored. This query will return all records where the name is “sonia” and the phone number is ‘9876543210’.