How to Select a Specific Row(s) from a Table in MySQL
Notes:
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;
Ex:
select * from tbl_faculty where id = 1;
select * from tbl_faculty where name = ‘rajesh’;
Interview Questions:
