Advertisements Im having issues with this mysql query, i need it to bring ONLY the files that have the condition WHERE st.class_id in (‘%s’) as principal, and the other conditions as secundary, tried changing the or’s to and’s with no luck, thanks in advance. $wpdb->get_results($wpdb->prepare("SELECT `st`.id,`st`.sub_name,`st`.stime,`st`.edate FROM {$_tables[‘subject’]} AS st WHERE `st`.class_id in (‘%s’) and… Read More issue with mysql query 'where' priority

Advertisements I’m noob in MySQL… It is difficult to describe my task, so I will show it with an example. I have two tables: meta_data: id key value 1 property_1 1,2,54,2 1 property_2 23424 1 property_3 cat 1 property_4 4324 1 property_5 3231 1 property_6 45 1 property_7 423424 1 property_8 868 1 property_9 2424… Read More MySQL. Select and split GROUP_CONCAT into different columns

Advertisements I’m currently writing a query and can’t seem to get it right, so I’m writing to get some advice. I have a props table [userId, name] (where name is a property). userId name 1 A 1 B 2 B 3 A 3 B 3 C 4 A Suppose have data like this To search… Read More A search query that has any one, or all, of the following

Advertisements For my current project, I have to use a MySQL database for managing a message system which is organized in threads. The database tables: User Table: (users) id (INT) unique_id (VARCHAR) Participant Table: (participants) ( user-id refers to the ID column of the User table ) ( thread refers to the ID column of… Read More How to make a MySQL query starting at the very end?

Advertisements create table employees(id int PRIMARY KEY, name varchar(30),salary int,department_id int); insert into employees values(1,’ruchi’,10000,2); insert into employees values(2,’ritu’,7000,2); insert into employees values(3,’rima’,7000,2); insert into employees values(4,’koel’,5000,1); insert into employees values(5,’huma’,2000,1); insert into employees values(6,’manav’,4500,1); insert into employees values(7,’sayan’,3500,1); insert into employees values(8,’shrey’,9000,2); insert into employees values(9,’garima’,1000,2); I want to get the top 3 highest… Read More Query to find 3 highest paid people in each department

Advertisements I would like to change the login password for a user using the following script: <?php #Salir si alguno de los datos no está presente if(!isset($_POST["email"])) exit(); #Si todo va bien, se ejecuta esta parte del código… include_once "conectar_pdo.php"; $password = $_POST[‘password’]; $email = $_POST[’email’]; /* Al incluir el archivo "conectar_pdo.php", todas sus variables… Read More Field not updated after executing UPDATE in MySQL table

Advertisements I have a date in a table formatted like this: 31-May-90 I need to get the year – 1990 in my MySQL statement. I tried: year(tblPhotoManage.Date) AS cpYear Obviously this won’t work. How can I get the year from this date format? >Solution : First convert the string that looks a bit like a… Read More Convert Date into a format to extract the Year in MySQL Select Statement

Advertisements I have mysql database in that i have below table values. mysql> select * from account_external_ids where external_id like "%rajesh.m%"; +————+———————–+———-+———————————————————-+ | account_id | email_address | password | external_id | +————+———————–+———-+———————————————————-+ | 1 | rajesh.m@company.com | NULL | gerrit:rajesh.m | | 1 | rajesh.m@company.com | NULL | http://160.155.187.158:8095/openidserver/users/rajesh.m | | 1 | NULL |… Read More How to delete one row in mysql?

Advertisements So I have two tables : Film : id | title | year | Director Casting : id | title | year | actors So What I am trying to do is to find all the actors that have the same title as the director. So what I am trying to do first is… Read More Mysql first look value and then search with value find

Advertisements I need to get all information about restaurant, but when Im doing a request, I have an error Table ‘restaurant-service.food_menu’ doesn’t exist, so I just don’t know how to fix it, but my post request is working excellent here is my database Domain Restaurant @Getter @Setter @NoArgsConstructor @Entity @Table(name = "Restaurant") public class Restaurant… Read More Table 'restaurant-service.food_menu' doesn't exist