I am stuck with this problem: I made 3 custom meta_key in wp_postmeta. Now I have to select all the records that contain in the column meta_value, one or more words, from a string I provide. This is the SQL…
How would one write a function in PostgreSQL to obtain a number in words? Input: 123 Output: Un Deux Trois One Two Three Input: 123.00 Output: Un Deux Trois . Zéro Zéro One Two Three . Zero Zero I tried…
I have the below tables: team col_name type id string name string coach_id string player col_name type id string name string team_id string main_skill_id string coach col_name type id string name string skill col_name type id string name string I'm…
I need to make an advanced query in Laravel hopefully using Eloquent to make that a collection but a query builder or raw normal SQL query is acceptable. I have users table with User model having relation: public function roles()…
How to replace one string to another one in mysql including language setting ? Example query for arabic language ( "ar" ) unfortunately it doesnt work :( UPDATE `wp_posts` SET `post_contant` = REPLACE(`post_content`,'str1','str2') FROM wp_posts WHERE post_status = 'publish' AND…
I have this table: affiliate_id parent_affiliate_id 4 5 3 4 2 3 1 2 6 5 8 7 10 9 12 11 What I need is to make a query that shows all parents of an affiliate. Expected outcome: affiliate_id…
I have this database table: post_id | key | value 297 | title | test 297 | price | 50 250 | title | test2 250 | price | 75 100 | title | test3 100 | price | 100…
I've got a production database with a wp_options table reportedly totalling around 951,679,500,288 (900GB+) in total data length. However, when I export the database and examine it locally it only reports a small number of MB (usually 3-7MB). There are…
I'm using this query which I found elsewhere that works fine. It basically returns a list of every category that the current author has posted in: global $wpdb; $categories = $wpdb->get_results(" SELECT DISTINCT(terms.term_id) as ID, terms.name, terms.slug, tax.description FROM $wpdb->posts…
I have two tables like this wp_posts ID post_date post_title post_type post_status 1 2020-12-10 ABC institute publish 2 2020-12-16 DEG institute publish 3 2020-12-11 XXY institute publish 4 2020-12-12 ABX institute publish 5 2020-12-24 ZYU institute publish 6 2020-12-28 ANM…