27,582
社区成员




substring(notes from 'Medications on admission:.*\n') as medications
select substring('ALLERGIES: The dddd.
Medications on admission: Synthroid, Trileptal, Lamictal, Klonopin, MOBIC, and Flagyl.
Physical Examination on Admission: Temperature 36.7 degrees, heart rate 85, blood pressure 138/78, respiratory rate 18, and O2 saturation 98% on room air. The patients physical examination is notable for an' from 'Medications on admission:.*\n') as medications
+------------------------------------------------------------------------------------------+
| medications |
+------------------------------------------------------------------------------------------+
| Medications on admission: Synthroid, Trileptal, Lamictal, Klonopin, MOBIC, and Flagyl.
|
+------------------------------------------------------------------------------------------+