Questions tagged [sql-like]
The LIKE predicate is used to search for a specific pattern in a column.
sql-like
3,216
questions
2
votes
1
answer
35
views
MYSQL is very slow when combing LIKE with EQUALS or IN, but not other OR operators [duplicate]
SELECT
products.*,
products_description.*
FROM
products
LEFT JOIN products_description ON products_description.products_id = products.products_id
LEFT JOIN products_rooms ON ...
0
votes
0
answers
37
views
Inner Join using Like Operator in Big Query
I have a list of c.11k strings that I need to partially match to string IDs within a BigQ table.
T1 is the original BQ table and T2 is a table with a column of the 11,000 strings
At the minute I have ...
0
votes
2
answers
78
views
SQL like query contains only a specific character
I'm trying to get records from SQL server starting with abc_ followed by at least one letter (a-z, A-Z) and then continue to the end with just letters and numbers (a-z, A-Z, 0-9). No special ...
0
votes
1
answer
60
views
SQL SELECT * FROM table WHERE column NOT LIKE '%str% 'isn't working, i feel kind of stupid
i got kind of upset about my inability to get this to work and since I've already wasted half a day on this rather simple problem I'll give up on it and ask you guys.
So i have a SQL table where the ...
0
votes
0
answers
20
views
GCP workflow condition using like %string%
May I know if workflow can use like, contained, or match?
I know can use == to be the condition, but how about like?
- Test: switch: - condition: ${Test like %complete%} steps: - Complete next: ...
0
votes
0
answers
68
views
How to use NOT LIKE in SQL with a string of words
I am having trouble excluding text in a field that starts with "Community Launch". I am using the code:
rp.project_name NOT LIKE 'Community Launch%'
but this is removing any text that also ...
0
votes
1
answer
98
views
MySQL(5.7.26) query optimization, why select * is much faster that select id in my leading wildcard query?
I have a leading wildcard query I know it is hard to optimize. I know if I use only the trailing wildcard I can do some optimization. But our client wants the leading wildcard because when searching ...
0
votes
1
answer
25
views
How to combine Sequel.or with Sequel.like? (mssql or sqlite)
I use ruby and sequel in my programm.
I want to execute a deletion in my DB like
DELETE FROM db.tbl WHERE col1 = 'a' and (col2 LIKE '%xxx%' OR col2 LIKE '%yyy%')
But I fail to build the statement ...
4
votes
2
answers
96
views
MariaDB LIKE with Escape Character - Unexpected Behavior
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\\...
0
votes
2
answers
29
views
Mysql LIKE or REGEXP
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 ...
0
votes
2
answers
72
views
Fastest way to compare two columns using like in two differents tables in MYSQL, half millions rows
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)...
0
votes
1
answer
39
views
pick a word from multiple words in a column using snow SQL
I have a column with this kind of data (web.at.menu.planning.clicked). I want to filter columns with .clicked so I used a like operator where column like '%.clicked' then column. But it is showing me ...
-1
votes
3
answers
95
views
Query that returns all words ignoring one
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,
`...
0
votes
1
answer
39
views
SQLite: Matching All Items Within a List of Characters
I am working with a table (essentially a list of words, i.e. a dictionary'), and had the need to create a subset of items from that table that only contained 3 certain characters, let's say, 'A', 'P', ...
1
vote
1
answer
64
views
Postgres queries contaning non-alphabetical characters
I'm developing a search for entities by name in Postgres database. Name usually consists of 1-3 words and may contain symbols &, !, (, ), -, etc.
I'm using gin trigram index and queries: WHERE ...