I want to compare system table points against a user's input answer, and give every specific combination a score, and order by that. The 2 columns to compare into a score are po.points and an.answer. Both columns can have a…
A fun little MySQL puzzle! Given the dataset id Description Amount Category 1 Food #1 1 1 2 Non-food #2 bla 3 2 3 Food banana 5 1 4 Non-food #2 foo 1 2 5 Non-food #2 foo bar 3…
I'm seeking help regarding full-text searching in MySQL. I have two tables, Article and Keywords. Article: id int, description (varchar(600)) Keyword: id int, value (varchar(50)), article_id int An article can have multiple keywords. For example: id:1, keyword1, article_id: 1 id:2,…
In MySQL Regular Expression pattern matching function, there is a 'match_type' - 'n'. Which represents, The . character matches line terminators. The default is for . matching to stop at the end of a line. Could someone explain me how…
I get MySQL ERROR 1064 (42000) when I try to run this code : create table articles ( `id` INT(11) NOT NULL AUTO_INCREMENT, `username` VARCHAR(30) NOT NULL, `title` VARCHAR(30) NOT NULL, `description` VARCHAR(255), `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIME, `users_id`…
Heads up: I'm a non-background who just learns bits from everywhere. In a personal project, I'm building a star schema for DWH on my local machine. In a fact table, I collected fields from 8 other tables (3 from OLTP…
I have an array of column headers and an array of corresponding values at the same index I need to update a row using both those arrays in SQL. I know this might not be the neatest way of doing…
I have two tables in my database as below: categories table: Column Name Column Type ID INT Name TEXT IDParent DOUBLE and advertisements table: Column Name Column Type ID INT IDUser INT DateAdded DATETIME IDCategory INT Price DOUBLE I have…
I have a list of alphanumeric strings that includes two special characters + and -. The input, as shown below, represents part numbers for our company's products. I would like to extract the individual components as an output. There are…
My unique SQL use case is as follows: I have userId, isCondition, timestamp I want number times all results per userId has timestamp always containing a starting substring and isCondition value has more than 1 distinct value amongst those results…