-
I have created the below code:with t as (select *, case when `2kids`= '1' then '2kids' else'' end as new_2kids, case when `3kids`= '1' then '3kids' else'' end as new_3kids, case......
-
I use MySQL, and I constantly struggle to find a fuction that returns an int of a char from a string where I can change the occurence of the chosen char.INSTR() returns the position of the first ......
-
I have a dataset with many text comments from a social media site. I want to find all instances where at least two country names are featured in the text. What I have right now looks like:SELECT * ......
-
Is there a way to run a query to select only the records that contains few words not the whole word?For example, In mysql table I have records with these codesproductColumnF2018%First%Shirt%Blue&......
-
I wanna display the attributes login, name, gender, address, and joined from the table Player if the login is a substring of name (case insensitive)For example,if login is 'thom' and the name is '......
-
I have this colom called package_type and it fills with string:TP-CYS01-01-2700-W-003TP-CYS01-01-2700-W-004TP-CYS01-02-2700-W-003TP-CYS01-02-2700-W-001I need to count the package_type but ......
-
SET @value = '';SELECT id, order_kind, property_kind, town, images, agreement, uprice, eprice, tprice, pprice, bprice, qprice, status, createtime, town_title, fullname, mobile, ......
-
I updated the database, after update I faced with duplicate products in woocommerce while I didn't have duplicate product in database,I deleted the transient but it not fixed, I will appreciate you ......
-
I have three tables: property, person, and company. One property can only belong to either a person or a company. A person or a company can have more than one property.My current database design is ......
-
I have 3 tables of data I'm joining together. I'm using an ID column (day) in each table to join the data together. The following SQL query works, and provides the following column set:SELECT * FROM ......
-
I’m doing a database design for user experience with specialties. A user can have experience months/ years for each specialty ( please see the attached images)I’m planning to create a table to list ......
-
For each customer-product pair, I need to calculate average sale of that product in each state.Actual table ("sales" table):cust | prod | state | quantBloom | Bread | NY | 1Bloom | ......
-
I have a case with a TSDB Hypertable looking approximately like this:CREATE TABLE data ( pool_id INTEGER NOT NULL, ts TIMESTAMP NOT NULL, noise_err DECIMAL, noise_val DECIMAL, signal_err ......
-
I have a MySQL In-App Database in azure, I can connect fine in PHP on a normal webpage, my issue is I am trying to create a webjob, but when ever I try the web job file can't connect to the database ......
-
CREATE TABLE Seller( Seller_ID int PRIMARY KEY, Name varchar(20), Address varchar(30), ContactNo varchar(20), EmailAddress varchar(30))CREATE TABLE Buyer( Buyer_ID int ......