hi... a basic select question/issue that should work....
mysql> select * from instructorTBL; +------------+--------------+--------+-----------------+-------+----+ | name | universityID | deptID | email | phone | ID | +------------+--------------+--------+-----------------+-------+----+ | dr. smith1 | 1 | 2 | [EMAIL PROTECTED] | | 1 | +------------+--------------+--------+-----------------+-------+----+ 1 row in set (0.00 sec) why don't any of the following work...??? as you can see, there is information in the tbl... mysql indicates it should work... what simple mistake am i missing..?? this is getting embarrassing... mysql> select instructorTBL.ID -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.00 sec) mysql> select ID -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.01 sec) mysql> select * -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.00 sec) thanks... -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]