Hi, > | BT-1034.02 > mysql> SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2';
I think you have a type .. instead of SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2' try SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.02' HTH, Markus ----- Original Message ----- From: "leegold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 07, 2004 4:51 AM Subject: select and where clause - help > I am trying to get a select statement with "WHERE" to work and > I can't seem to do it. Below find some output. I try a select > w/WHERE by "book" but it doesn't work. Originally I tried > in PHP and didn't work, so now I just want the MYSQL to work first, I > could be overlooking something simple since I'm new to MYSQL. > Thanks, Lee G. > > > > mysql> show columns from balloon.balloon_txt; > +-----------+-------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-----------+-------------+------+-----+---------+-------+ > | access_no | varchar(20) | | PRI | | | > | recs_txt | text | YES | | NULL | | > +-----------+-------------+------+-----+---------+-------+ > 2 rows in set (0.00 sec) > > mysql> SELECT * FROM balloon_txt limit 0,1; > +--------------+---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- ------------------------------------------------------------------------------+ > | access_no | recs_txt > > > | > +--------------+---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- ------------------------------------------------------------------------------+ > | BT-1034.02 > | Title_____[ Balloon Capabilities and Futures] > Author____[ Thomas W. Kelly > Resp_Org__[ Air Force Cambridge Research Labs. > FundingOrg[ > Date______[ Dec 1963 > Report_No_[ Found in: AFCRL-TR-63-919, AFSG No. 154 > Reposit_No[ Found in: AD-614 065 > ContractNo[ > Descript__[ Conference Paper, 25 p > Notes_____[ This symposium was held in Boston, MA on 25 to 27 September > 1963. Twenty papers were presented, of which 16 were published. This > paper is found on pp 3-27.] > Subj_Terms[ Balloon technology, tethered balloons, payload orientation, > hot air balloons, balloon design, manned balloons, instrumentation] > Content___[ The papers covered present load and altitude capabilities of > many types of plastic balloons. Objectives of current research in > balloon technology are described, including extension of present > capabilities, increased reliability, and longe > r duration.] > ElecAccess[ http://library/Databases/Balloon/Data/BT1034.02.pdf > Avail_From[ WFF/BTL | > +--------------+---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ > ------------------------------------------------------------------------------ -------------------------------------------------------------------------------- ------------------------------------------------------------------------------+ > 1 row in set (0.00 sec) > > mysql> SELECT * FROM balloon_txt WHERE access_no = BT-1034.2; > ERROR 1054: Unknown column 'BT' in 'where clause' > mysql> SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2'; > Empty set (0.00 sec) > > mysql> SELECT * FROM balloon_txt WHERE access_no = "BT-1034.2"; > Empty set (0.00 sec) > > mysql> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > ---------------------------------------- My Inbox is protected by SPAMfighter 1138 spam mails have been blocked so far. Download free www.spamfighter.com today! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]