Title: Select query from longtext ( array )
Last modified: August 19, 2016

---

# Select query from longtext ( array )

 *  [ashwinnaidu](https://wordpress.org/support/users/ashwinnaidu/)
 * (@ashwinnaidu)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/select-query-from-longtext-array/)
 * Hello,
 *     ```
       <?php
       $query = $wpdb->get_var($wpdb->prepare("SELECT meta_value FROM usermeta WHERE meta_key='paypal_user' and user_id=5"));
       echo $query;
       ?>
       ```
   
 * Above query returns the following string
 * > O:11:”Paypal_User”:8:{s:8:”duration”;i:0;s:13:”duration_type”;s:1:”m”;s:6:”
   > amount”;i:0;s:8:”currency”;s:0:””;s:13:”last_pay_date”;s:0:””;s:11:”expire_date”;
   > s:0:””;s:12:”account_type”;s:25:”$5 for 1 Year (Platinum)”;s:10:”status_str”;
   > s:0:””;}
 * I want to pull only the s:25 which is “5 for 1 Year(Platinum)”
    How do I do that?
 * thanks,
    Ashwin.

The topic ‘Select query from longtext ( array )’ is closed to new replies.

 * 0 replies
 * 1 participant
 * Last reply from: [ashwinnaidu](https://wordpress.org/support/users/ashwinnaidu/)
 * Last activity: [15 years, 6 months ago](https://wordpress.org/support/topic/select-query-from-longtext-array/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics