Why this SELECT "»" REGEXP "^[-а-я]*$" SQL statement returns 1 (true). Symbol "»" doesn't match this regular expression. In other case, it works correctly with symbol "«": BINARY after REGEXP doesn't resolve problem
[sql tuning] How to tune in this situation? erd as above enter image description here SELECT store0_.store_id as store_id1_10_, store0_.address as address2_10_, store0_.business_name as business3_10_, store0_.business_number as business4_10_, store0_.business_start_date as business5_10_, store0_.category_id as category11_10_, store0_.name as name6_10_, store0_.member_id as member_12_10_,…
I'm working on a courses Application where the user can sort his content however he like for example say there is Courses Table - contains course data(title, thumnail...) sub-courses and videos Videos Table - contains video data(video url, title...) so…
My table looks like below x y z a ab 2 a ab 4 a ac 4 b ab 6 b ab 4 b ad 8 c ac 10 c ac 10 What I am looking for is this: x…
I trying to fetch data from two related tables using a foreign key and keep the data as separate records / objects. The best solution I have found so far is using JOINs with column prefixing to differentiate between the…
I have a schema like this one: create table users ( id bigint primary key generated always as identity, name text not null ); create table feature ( id bigint primary key generated always as identity, value text not null…
I came to a standtstill with a relatively trivial issue. Such a simple query: select distinct field_name,length(field_name) from table_a where field_name similar to `2[0-9][0-9]%`; returns the following rows: field_name|length| ----------+------+ 200 | 3| 203 | 3| 210 | 3| But…
#1241 - Operand should contain 1 column(s) SELECT name FROM tabel WHERE n1 IN ( SELECT key1,key2,key3 FROM tabel2 ) but if try : SELECT name FROM tabel WHERE n1 IN ('1','2','5') its work thanks
For context here is a simplified way of my DB Structure Table definitions and data sample : CREATE TABLE `screens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `playlist_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ; CREATE TABLE `playlist` ( `id`…
Im trying to get all unique values out of two rows in a databank as a list. Using postgresql and python. I use this sql query: SELECT DISTINCT from,to FROM database; I get this output from | to ------+----- a…