I have the following query that bring the posts that contain a specific word in the title SELECT posts_post.ID AS post_ID, posts_post.post_date AS post_post_date, CONCAT('<a href="',posts_post.guid,'">',posts_post.post_title,'</a>') AS post_title_with_link_to_post FROM wp_posts AS posts_post WHERE 1=1 AND posts_post.post_title LIKE '%HOTARAR%' AND posts_post.post_type…
In my database, I have table wp_postmeta, example: | meta_key | meta_value | post_id | --------------------------------- points | 12 | 23 points | 2 | 18 lorem | ipsum | 92 points | 8 | 15 I want to order…
Im writting a code for my assigment "So,im now at view profile page when i click the button it will redirect to the update profile page when I hover the button the url is right but the button still stay…
I'm currently trying to find a way to return all rows in which there is at least one other row with the same values in any number of columns and unique values in any number of other columns. I want…
Data base and tables to be used: DROP DATABASE IF EXISTS employees; CREATE DATABASE employees CHARACTER SET utf8mb4; USE employees; CREATE TABLE department ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, budget DOUBLE UNSIGNED NOT NULL, expense…
anybody know how can I convert the inconsistent value column (contain both number and text) into number? like this 4.5M => 4500000, 7M => 7000000 I tried convert but it doesn't give me an expected answer. Thank you so much
id lessons 1 ["3M-232","3M-313"] 2 ["3M-311","3M-312"] 3 ["3M-443","3M-565"] 4 ["4M-232","4M-313"] 5 ["4M-311","4M-312"] 6 ["4M-443","4M-565"] How can get rows that match lessons with "3M-232" as one of them SELECT * FROM merged_lesson where lessons = "3M-232"; Expected only row 1 to…
How do I redirect users after they have either registered or login from either login page or register page to the main page I tried using the header func(location:) but when I try it the page says the url cannot…
I am trying to do a simple query in WordPress ordered by a meta_value_num of a custom field, the problem is that not all the inputs have a value so it gives me a null value and it does not…
I put the code below in a single post page. The problem is it displays correct title of the current post but incorrent count number. It shows count 0, when the actual count is 1. Current post has purchased=yes and…