Title: Data Format and SQL Queries
Last modified: November 12, 2016

---

# Data Format and SQL Queries

 *  [awstyle](https://wordpress.org/support/users/awstyle/)
 * (@awstyle)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/data-format-and-sql-queries/)
 * In the latter years of my working life I was extracting data using SQL on a daily
   basis but I never came across data stored in this format.
 * a:1:{i:0;a:3:{s:4:”book”;s:10:”John”;s:7:”chapter”;s:1:”3″;s:5:”verse”;s:1:”16″;}}
 * No doubt this format has a special name.
 * Can anyone tell me how to construct a SQL query to extract, say, book and chapter
   from this data which is held in a field called Start

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Keith](https://wordpress.org/support/users/keithdriscoll/)
 * (@keithdriscoll)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/data-format-and-sql-queries/#post-8425778)
 * If you are trying to get data from the database within WordPress you might want
   to start here : [https://codex.wordpress.org/Class_Reference/wpdb](https://codex.wordpress.org/Class_Reference/wpdb)
    -  This reply was modified 9 years, 6 months ago by [Keith](https://wordpress.org/support/users/keithdriscoll/).
 *  Thread Starter [awstyle](https://wordpress.org/support/users/awstyle/)
 * (@awstyle)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/data-format-and-sql-queries/#post-8425808)
 * Thanks Keith
 * Seems I have some bed time reading to do.
 * Kind regards
 * Tony
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [9 years, 6 months ago](https://wordpress.org/support/topic/data-format-and-sql-queries/#post-8425821)
 * You’re looking at a serialized array. [http://stackoverflow.com/questions/8641889/how-to-use-php-serialize-and-unserialize](http://stackoverflow.com/questions/8641889/how-to-use-php-serialize-and-unserialize)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Data Format and SQL Queries’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [9 years, 6 months ago](https://wordpress.org/support/topic/data-format-and-sql-queries/#post-8425821)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics