There is likely no “cp_job” column like you are thinking. extra data/information about a wordpress post type (it looks like ads is a custom post type here) would be stored as post meta in the database.
So you might see something in the wp_post_meta table like:
meta_id | post_id | meta_key | meta_value
XX | XX | _cp_ad_type | buyer
Once you know the name of the meta key you are looking for, you can query for this data using a WP Query. Pay extra attention to the section called Custom Field Parameters which describes how to do a meta query
Related Posts:
- How to return number of found rows from SELECT query
- $wpdb->delete column values IN ARRAY()?
- WPDB: how to get the value of a field in a custom database table
- Any possible way to make $wpdb->get_results() return anything else than array?
- database interactions using OOP
- Trying to establish connection to External Database
- Getting id of poll from WP database
- How to insert a single row to WP database table?
- $wpdb->update with multiple parameters gives error
- Update results, Before deleting the related category [closed]
- How WordPress reacts to a lack of memory of the server [closed]
- How to retrieve the data from the sever and displaying it in a page?
- I can’t update my data through $wpdb
- wpdb Cannot Update column in Database
- Delete database record using plugin from admin panel
- Wpdb get->results to out the the month from the db
- WPDB – Read and write value from / to database
- How to Generate a list of Most Commented post?
- Add row to custom database Table and delete all rows older than 1 day
- select a single val though a table in wordpress
- Add posts to custom table in database instead of wp_posts
- Using wpdb to connect to a different database is not working
- How to grab data from input and store it into custom table in database?
- Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
- Querying multiple meta_keys in WordPress SQL query
- MySQL database migration to WordPress
- Fetching wpdb data from a php file seems to break?
- Insert into db with foreach problem
- How to get data (not value or name) from radio options to POST to database
- Putting form result in my database
- queries inside of a class
- How to Join two tables from separate databases within WordPress
- Refresh page after update_post_meta
- Search and Replace in database: How to replace data in SQL dump file on Windows?
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- Import 10,000 Users into WordPress WITH a specific ID for each user
- WP database error for comments_popup_link()
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- How to create Sub Sub domain Multi User blogs?
- How to generate page content from database the right way?
- Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
- Converting MYSQL to WordPress $WPDB
- How to Fetch values from WP database based on selected option value by onchange using PHP?
- Store and Work with huge array in WP [closed]
- phpMyAdmin displays error when importing database
- Adding Custom Forms
- Why is variable not working on custom sql query using wpdb?
- How to get the POST TITLE using the POST ID?
- Why is the post meta[] empty when I make a call to the wordpress rest api?
- Is it necessary to sanitize wp_set_password user input?
- Store a default value for a transient on plugin activation
- Split reads to a different connection string
- custom user role wordpress – grant guest access to edit.php without insert/update/delete
- wp query foreach deleting record returning only first or last item
- inserting a post from an extern php file but post content doesn’t show on wp site
- Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
- Display Data in Table from External Database in WP using Shortcodes
- Error using WordPress $wpdb object to get result from custom table
- how to get serialized post meta
- Saving data from custom form in wordpress database
- Basic wpdb update question
- Lost in trying to create user database system
- Cannot access $wpdb, comes back NULL
- form $_post action value gets truncated after it passes through two forms
- Adding data to custom wordpress database table
- Undefined variable: row?
- populate select options from extra mysql table data
- Using PHP Code Snippets to query a database, $dbconnection->get_results is outputting nothing
- Please help! I have a problem with getting wordpress databas
- Creating multiple tables with Plugin
- Error establishing a database connection (configuration)
- Conditional formatting on data fetched from MYSQL
- Displaying SQL query result from user input via wpdb
- Editing the term_order field
- How do I fetch a data from an external database into my wordpress homepage
- Full search and replace isn’t enough to make all pictures to be loaded with https
- Generate random access token to a post page
- Update user_email via php – WP 4.7
- direct query to post_meta table
- Unable to pass variable to database
- Child theme functions.php file change database entries
- special characters not supporting in wordpress
- How to set max users to 17.000
- Check if values exists DB
- Host does not allow remote connection, so how do I transfer data to my WordPress site?
- MySQL Engine vs. Charset
- Custom query_posts() parameter
- How to print array of specific item
- How do you get a reference to $wpdb in a PHP script
- Display total count of products in orders of a specific order status
- How to display inputted data in Ajax without button or click event
- How do I empty a specific meta_value for all users in PHP
- Create custom table for wordpress custom registration flow
- Custom form that stores data in mysql database
- Creating a table via dbDelta
- wpbd to connect to a VPS mysql database
- Retrieve data from external database and insert back in
- How to get the last date updated of postmeta?
- SQL – How to echo out inside of where statement
- How can I update a value of a field depending on outside source?