Sql New Question

• SQL delete unnecessary characters from a row and p

  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......

  mysql  sql  string  case  sql-null  Read Article

• MySQL function that finds the occurence of certain

  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 ......

  mysql  sql  string  integer  position  Read Article

• PostgreSQL logical AND for finding two values in t

  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 * ......

  sql  string  postgresql  count  where-clause  Read Article

• SELECT record which contains some words not the wh

  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&......

  mysql  sql  string  where-clause  sql-like  Read Article

• Postgresql check if an attribute is a substring of

  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 '......

  sql  string  postgresql  where-clause  sql-like  Read Article

• select substring with dashes in sql

  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 ......

  sql  string  count  aggregate-functions  Read Article

• Unknown Column In Where Clause (as)

  SET @value = '';SELECT id, order_kind, property_kind, town, images, agreement, uprice, eprice, tprice, pprice, bprice, qprice, status, createtime, town_title, fullname, mobile, ......

  mysql  sql  string  where-clause  sql-like  Read Article

• How to remove duplicate product with same product

  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 ......

  mysql  wordpress  woocommerce  Read Article

• Database design - two foreign keys but one is alwa

  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 ......

  mysql  sql  database  postgresql  database-design  Read Article

• MySQL - removing ID columns used for joining

  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 ......

  mysql  sql  database  Read Article

• Database design for user experiences with various

  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 ......

  mysql  database  Read Article

• SQL: How do I change my query to get the following

  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 | ......

  mysql  sql  database  Read Article

• High speed single row inserts with PostgreSQL &

  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 ......

  postgresql  performance  postgresql-12  timescaledb  data-ingestion  Read Article

• Connect to MySQl In App Database In Azure Webjob

  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 ......

  mysql  azure  azure-webjobs  Read Article

• Unable to fetch the result for this query

  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 ......

  sql  database  Read Article