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…
The query outputs lines with more than one comma, but I only need ONE comma and ONE semicolon SELECT * FROM table WHERE history_coord is NULL OR history_coord LIKE '%,%' AND history_coord LIKE '%;%' How do I change the request?…