/* using a where clause */

SELECT  *  FROM  student
WHERE  fname = 'David';



/* if value is numeric, no need for quote */

SELECT  *  FROM  student
WHERE  student_id = 9;