- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we fetch a particular row as output from a MySQL table?
For fetching a particular row as output, we need to use WHERE clause in the SELECT statement. It is because MySQL returns the row based on the condition parameter given by us after WHERE clause.
Example
Suppose we want to fetch a row which contains the name ‘Aarav’ from student table then it can be done with the help of the following query −
mysql> Select * from Student WHERE Name = 'Aarav'; +------+-------+---------+---------+ | Id | Name | Address | Subject | +------+-------+---------+---------+ | 2 | Aarav | Mumbai | History | +------+-------+---------+---------+ 1 row in set (0.00 sec)
- Related Articles
- How can we fetch one or more columns as output from a MySQL table?
- How can we fetch all the records from a particular MySQL table?
- How can we delete a single row from a MySQL table?
- How can we fetch alternate even-numbered records from MySQL table?
- How can we fetch alternate odd numbered records from MySQL table?
- How can we fetch a second highest salary of an employee from a MySQL table?
- How can we insert a new row into a MySQL table?
- How can we update MySQL table after removing a particular string from the values of column?
- How can you retrieve a particular number of records from a table starting from some specified row number in Python MySQL?
- How can we fetch a MySQL SET column as a list of integer offset?
- How we can find all the triggers associated with a particular MySQL table?
- How can we remove a column from MySQL table?
- How can we use MySQL self-computed output from any expression, function etc. for inserting values in a row?
- How can fetch records from specific month and year in a MySQL table?
- How can we search a record from MySQL table having a date as a value in it?

Advertisements