It’s just serialized, in WordPress, you can run maybe_unserialize and get back the variable/array.
$crosssells = $wpdb->get_results(
"SELECT *
FROM $wpdb->postmeta
WHERE _crosssell_ids <> ''
"
);
$array = maybe_unserialize($crosssells);
However, there are built in functions to retrieve posts based on meta information. You can use get_posts to retrieve the posts and get_post_meta to retrieve meta information from a specific post id. It’s best to abstract away from direct database interaction to take advantage of the built in caching, security, etc of WordPress.
Related Posts:
- How to print the excuted sql right after its execution
- Pagination with custom SQL query
- Return only Count from a wp_query request?
- how does $wpdb differ to WP_Query?
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Query causing load because of SQL_CALC_FOUND_ROWS post counting?
- Use WP_Query with a custom SQL query
- How to make an activities stream mixing posts and comments?
- How can I connect to another WP database and use WP_Query?
- Get number of comments after modifying comment query
- How to change a custom query into a standard loop?
- How to count data records in wordpress which have same meta_value in wp_postmeta table?
- Should close $wpdb via $wpdb->close()
- $wpdb->insert inserting two rows in database
- Get the Plugin Which Triggered a MySql Query in WordPress?
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- Detect featured image among the attached images
- How would I format a query that depends on post parent taxonomy
- Mysql query LIKE not working
- Select from wp_post and multiple meta_value from wp_postmeta
- Order by custom table and multiplication
- How to correctly pass values to wpdb->prepare()?
- $wpdb select date range of posts
- What’s the purpose / logic of split_the_query in WP_Query->get_posts
- How to delete taxonomy term when a wordpress user is removed?
- Custom Query num_rows returns wrong amount
- Getting post revision and printing them on the post content site
- Filtering posts from different categories into different section by doing WP_Query only once
- Iterating through $wpdb query without using get_results for large query results
- Query with search and subscribers only output
- wp_Qwery works to slow
- How to query custom post types with mixed AND & OR statements for custom fields
- Query most popular terms by taxonomy over 2 week period
- Which is faster wpdb & get_row or wp_query & ge_post_meta?
- Custom query: Get all posts that are from a certain category?
- How to access custom WordPress database tables
- How to pass orderby params to $wpdb->prepare()?
- Ajax future single post query doesn’t work when NOT logged in
- Conditional sorting with variable using WP Query
- Is it safe to access the underlying mysqli object from \wpdb for custom queries?
- Make a SQL query with wpdb in WordPress
- WordPress query posts with multiple post_meta data
- List of ways to access WordPress database?
- Specify strict ‘order by’ in WordPress query
- Does WordPress have something like Drupal’s DB API?
- get_post() is not returning correct value
- Disable (or limit) queries when certain content (or data) is not needed (or showed)
- get_var is neither a string, integer, or array …?
- Use have_posts() with array of post results retrieved by $wpdb->get_results
- how to translate countries output from wp database?
- What’s wrong with this wpdb query?
- duplicated posts when using pagination
- Passing a SQL query to the WP Query
- Save queried result into database
- Any way to use FETCH_KEY_PAIR with $wpdb?
- Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
- How to get user avatar via WPDB
- In which file to use $wpdb and its functions for database operations and queries in wordpress?
- What argument does my function need to echo get_results() query results
- complex query question
- Select Unique Posts for a List of Tags
- How To Use WP_Query To Get The Custom Post type Posts With Keywords
- Include post_status check within $wpdb query
- wpdb get_results() returns only 2 rows
- Optimising amount of calls to custom fields
- pre_get_posts or $where, which one to use?
- Fire query on ajax post url page
- Slow getting posts from category
- Search Query that Includes Custom Table
- Custom query (author is post_author or meta co_author) with Pagenavi pagination
- WP_Query search by multiple meta key and distance
- Different sql queries count indicator on the main page [closed]
- wpdb LIKE request shows all database data
- Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
- How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
- how to use transient method?
- get_post_meta bringing back results, but $wpdb->postmeta doesn’t
- Is there another way to retrieve a post_id from post_meta other than a SQL query?
- Add indexing to meta_value in wp_postmeta
- Querying by taxonomy vs Querying by Custom fields Speed Comparison
- Include Sticky Posts with Custom Query
- Order WP Query posts by custom order calculated from post meta values
- WP_Query mixe post and page attributes
- How do you Query posts with nothing in common?
- When to add_filter() to Custom Query
- Query all published post AND attachment with specific mime type
- How to list custom fields as headers and list all pages sharing that custom field under it?
- How to set an alternate posts_per_page value for default queries in different templates
- Query posts using less than
- Using WHERE on a WP_Query
- Query posts by post type, author and post meta
- pre_user_query vs pre_get_posts
- Can I alter the main loop to ‘orderby’ a custom callback?
- Query a database based on form input then output to another page [closed]
- Query for getting posts with their custom fields data in WordPress
- WP_Query not returning any posts
- Pagination doesn’t work for home page custom post type query
- have_posts order by title descending
- How to handle wp_query?
- Pagenavi with archive page