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)

Ayyan

Published on 19-Feb-2018 10:50:23

• Related Questions & Answers
• 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 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 fetch alternate even-numbered records from MySQL table?
• How can we fetch alternate odd numbered records from MySQL table?
• How can we remove a column from MySQL table?
• How can we fetch a MySQL SET column as a list of integer offset?
• How can we search a record from MySQL table having a date as a value in it?
• How can we update MySQL table after removing a particular string from the values of column?
• How we can find all the triggers associated with a particular MySQL table?
• How can you retrieve a particular number of records from a table starting from some specified row number in Python MySQL?
• How can we drop UNIQUE constraint from a MySQL table?
• How can we delete multiple rows from a MySQL table?