JOIN and SUM different statement results (Mailster Database)
get_terms with specific id order
Ok, if someone in the future also needs something like this, I found the solution after some time of playing with regular expressions. This worked for me: UPDATE `wp_posts` SET `post_content` = REGEXP_REPLACE(`post_content`, ‘https:\/\/www\.example\.com\/magazin\/(.*?)\/”>’, ‘https://www.example.com/magazin/\\1″>’); Example in action can be seen here: https://regex101.com/r/3ZPylJ/1 Hope it helps! Smile to all 🙂
SQL query – get a featured image’s alt / alternative text
Yes, you can. WPDB Class is quite beneficial in manipulating the database. https://developer.wordpress.org/reference/classes/wpdb/
Sql query does not work well
how to delete in phpmyadmin sql – all users with certain condition and all dependencies
You can put your meta_query in a variable to achieve the desired result. Then you can fill the variable with your actual meta_query when your condition is met. Check out the code below. $meta_query = array(); if ( isset($_GET[‘scope’]) && !empty($_GET[‘scope’]) ) { $meta_query[] = array( ‘key’ => ‘name’, ‘value’ => $_GET[‘scope’], ‘compare’ => ‘=’ … Read more
Adding CASE in WP_Query
Why are you using direct SQL query instead of wp_insert_post()? I see that you seem to be using non-standard database object. It is hard to guess what goes wrong if you are doing something considerably different from native mechanics.