On Tue, 06 Jul 2004 23:24:13 -0400,
[EMAIL PROTECTED] said:
> from your output it's not really possible to tell, but i suspect that
> there are spaces following (and/or possibly in front of) the
> "BT-1034.02" value, which would cause your select to fail to find
> anything.
>
> try:
>
> SELECT * FROM balloon_txt WHERE access_no like '%BT-1034.2%'
>
> if that works, remove the "%" at the front of the value. if that
> still works, check for tailing blanks. [if that doesn't still work,
> check for leading blanks.]
>
Here's what works re. your suggestion- what do you think of this?
I tried leading and trailing blanks but only the below is "telling",
of what I'm not sure...? If any % are removed it won't work. (?)
mysql> SELECT * FROM balloon_txt WHERE access_no like '%BT-1034.%2\r\n';
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 |
|
BT-1034.12
|Title_____[ High Altitude Survey Balloons]
Author____[ A.D. Struble
Resp_Org__[ Sea-Space Systems, Inc.
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, 13 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 169-181.]
Subj_Terms[ Balloon design, balloon materials, polyethylene, balloon
launches, flight tests]
Content___[ A small balloon has been developed which can achieve
altitudes up to 150,000 ft. A new balloon fabric - MERFAB - is used.
Because of its very light weight and high strength, MERFAB allows the
construction of balloons with extreme altitude
performance. Objectives of this balloon design include launching ease,
along with reasonable cost and good reliability. One intent of the
concept is to allow one man launching in elevated winds. Recent flight
experiences have indicated very satisfac
tory results.]
ElecAccess[ http://libraryDatabases/Balloon/Data/BT1034.12.pdf
Avail_From[ WFF/BTL |
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.02 sec)
mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
