I have the following MySQL tables: CREATE TABLE `person` ( `id` int NOT NULL AUTO_INCREMENT, `reference` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; INSERT INTO `person` (`id`, `reference`, `email`) VALUES (1, ‘PK001’, ‘paulk@gmail.com’); CREATE TABLE `review` ( `id` int NOT NULL AUTO_INCREMENT, `review_type` varchar(255) NOT NULL, `review_body` varchar(255)… Read More Concatenate MySQL result (Join?)

Is it possible to split a word into separate lines? All the examples I found were using something to refer to as a comma or something, but I would like to separate each letter from a word, eg: from (my table): id name 1 banana to: SELECT … id letter 1 b 1 a 1… Read More How split word in rows Mysql

I am implementing the cashback functionality with expiry feature. I am trying to redeem the partial amount based on early expiry date. I’ve already ordered the rows based on expiry date with the following mysql command. SELECT * FROM `cashback` WHERE `user_id` = 1 and `used`= ‘NO’ AND IF(CONCAT(`point_expiry`) !=’0000-00-00 00:00:00′, `point_expiry` >= NOW(), NOW())… Read More Find the matched rows based on redeem value in MySQL

CREATE TABLE IF NOT EXISTS botPatterns ( `boltP` varchar(200) NOT NULL ) ; INSERT INTO `botPatterns` (`boltP`) VALUES (‘6X135/6X139.7’), (‘8X165.1’), (‘8X165.1/8X170’ ), (‘8X170’ ); CREATE TABLE IF NOT EXISTS Vehicles ( `Brand` varchar(200) NOT NULL, `Pattern` varchar(200) NOT NULL ) ; INSERT INTO `Vehicles` (`Brand`,`Pattern`) VALUES (‘Audi’,’6X135′), (‘Audi’,’8X165.1′), (‘BMW’,’8X170′ ), (‘Ford’,’9X139.7′ ); What I need… Read More mysql query to filter LIKE combined with IN

This is the code where this used to verify the token by getting it from url and matching it with databse. and when matches it updates a db field and gives a alert that account is verified according to code. It works good. but when url token is wrong and it doesnt updates databse field… Read More else function is not wroking even query fails

Ok so Im using the following query SELECT `inquiry_source`.`source` AS ‘Source’, `inquiry_source`.`colour` AS ‘Colour’, SUM( CASE WHEN `inquiry_source`.`source` = `customer_migration_details`.`Acquisition_Source` THEN 1 ELSE 0 END ) AS ‘count’ FROM `inquiry_source` JOIN `customer_migration_details` ON `customer_migration_details`.`Acquisition_Source` = `inquiry_source`.`source` WHERE `date_opened` = ‘2023-01-23’ AND `Acquisition_Source` != ” GROUP BY `Acquisition_Source` Which in phpMyAdmin show the following results Source… Read More php/mysql phpmydamin server differances

I have 3 tables: formulario, viaverde and reparacoes. one of the fields is equal in all tables, called matricula, i’m trying to group every arithmetic operation to it. but i keep getting the error of matricula is ambiguous or synthax errors, how can i achieve this? i tried the following code: JOIN ( SELECT matricula,… Read More 3 tables sql sum divided by a minus between two fields not working

Getting Error Code: 1054. Unknown column ‘identification’ in ‘field list’ using this simple insert: insert into document (`title`, `patient_id`, `file_type`, `doc_type`, `identification`) values (‘VISA BLUE GRACE2.png’, ‘122’, ‘image/png’, ‘document’, ‘0’); Existing stackoverflow answers talk about using backticks vs. single / double quotes which I believe I’m doing correctly here. Omitting the column from the insert… Read More Mysql – unknown column in 'field list'

I am trying to write a query that can match a list of strings on a subquery. Example TableA id value 1 somevalue1 2 somevalue2 TableB id value tableA_id 1 test1 1 2 test2 1 3 test1 2 I need a query that returns all the entries from TableA who have an entry in TableB… Read More MySQL how to compare list of strings with subquery

I am trying to connect to a remote database and the credentials are correct but I get an error and I would like to know why ‘localhost’ is turned into a % sign and why I am unable to connect. If I use the full remote URL of the database the same thing happens. Here… Read More Why is my localhost turned into a percentage sign