How to Select a Specific Row(s) from a Table in MySQL


How to select a specific row(s) from a table in MySQL:
- To select a specific row(s) from a table; we take help of select command and where clause.
- where clause allows us to specify search criteria
- search criteria must be a Boolean expression

Basic Syntax:
select * from tablename where search¬_criteria;

select * from tbl_faculty where id = 1;
select * from tbl_faculty where name = ‘rajesh’;

Interview Questions: