I create an index this way: CREATE INDEX rep_tval_idx ON public.rep USING btree (t, lower(left(val, 127))); Then I run a SELECT with matching filter: explain select * from rep where t=3 and lower(left(val, 127)) like 'operation%'; According to EXPLAIN the…
I'm working on a Laravel application with a jobs table containing job data in the payload column. The payload is a JSON string similar to this: {"displayName":"App\Jobs\V1\ProcessOrdersPendingCourier"} I want to fetch records where the displayName key in the JSON payload…
I am trying to select all the strings has word ABC1 in it. But getting wrong answer with LIKE query. Not sure how to get exact answer. Below is the string format in a column: "SomeString ABC1000 Other"; And I…
I have a MYSQL database with a table 'product', about 500 000 rows, with a column 'oem' (varchar 255, utf8_unicode_ci). I have another table 'oem' with a column 'oem' too (varchar 255, utf8_unicode_ci), about 150 000 rows. I need to…
I have this table with the next records: CREATE TABLE `t_vias` ( `id` int(11) NOT NULL, `cpro` varchar(2) NOT NULL, `cmum` varchar(3) NOT NULL, `cpos` varchar(5) NOT NULL, `mun` varchar(75) NOT NULL, `via` varchar(100) NOT NULL); INSERT INTO t_vias VALUES…
I have huge words table which I'm running LIKE query on: create table words ( id int, word varchar ) It works pretty long. Index doesn't help a lot, so I'm trying to partition it by word column: create table…
select sum(case when '%sys%' like any(series_arr) or 'displays' = any(lob_arr) then revenue else 0 end) as sys_displ_revenue from mytable Basically, when I run this query, the term '%sys%' like any(<array column>) seems to get ignored, and only the 'displays' revenue…
I am using multiple concat with like but I am not getting all the output from the table. I am using below SQL query below in the database. select company_id as ID, concat( c.list_rank, '|||', c.company_name, '|||', c.company_size, '|||', c.industry…
I have a table with login names. Login names does not contain any special character just [a-zA-Z0-9] and of type varchar(50). I would like to find a user by login name eg.: CREATE TABLE users( login character varying(50) ); INSERT…
I am trying to match keywords using multiple LIKE's, however I would like to be able to do something like this: SELECT * FROM `keywords` WHERE keyword LIKE '%pp%' AND keyword LIKE '%p%'; to match "hippopotamus" but not "hippo". I…