Learn basic SQL before you start working with Databases.
Code:
SELECT Field1, Field2, (....) FieldX FROM TableX WHERE FieldX = "Value"
Or to select all fields:
Code:
SELECT * FROM TableX WHERE FieldX = "Value"
Here,
' WHERE FieldX = "Value" ' is the condition. Like, in Table1, if the row you want has the Name field as "ABC", you give:
Code:
SELECT * FROM Table1 WHERE Name="ABC"