Questions tagged [string-searching]
For questions about searching a string for matches
14
questions with no upvoted or accepted answers
2
votes
1
answer
57
views
Moving window search which stops at longest substring matches
I'm trying to create a search which searches a field for a longest matches possible and then stop.
Here's the basic idea in Python for single match:
import re
def generate(txt: str) -> list:
s ...
2
votes
0
answers
206
views
Full text index search with character at the beginning
I am looking at tables like this (I did not design them):
CREATE TABLE EventIDsToSearch (id int not null)
insert into EventIDsToSearch values (1)
insert into EventIDsToSearch values (92)
insert into ...
2
votes
0
answers
85
views
Searching across collections based on different column name
I have following collections with fields in my mongodb database:
Collection: Category
[
{
"cat_id": "cat_id_1",
"cat_name": "education"
}...
2
votes
0
answers
46
views
How to implement a "Command T" (VIM) -like search
I am thinking of implementing a string search similar to the command-t search in VIM. The context is almost the same: Finding Files in a Webapp.
It's not easy to explain how the command-t search ...
1
vote
0
answers
611
views
Optimize select query with OR and ILIKE
I have the following query for my PostgreSQL 13 database:
SELECT * FROM "user"
INNER JOIN "comment" on "comment"."user_id" = "user"."id"
...
1
vote
0
answers
108
views
Search by first and last name of the Instructor
I have the below tables in the MySQL database
create table course_class
(
id varchar(36) not null primary key,
class_code varchar(255) not null,
...
1
vote
0
answers
81
views
Searching for and parsing out specific text parts within the values of a column
I'm working on a CASE expression that I need to have in order to search for, and parse out, specific text values.
Sometimes the relevant column will contain a person's name, and sometimes it will ...
1
vote
1
answer
897
views
Perform SELECT using WHERE IN clause on JSON Object in MySQL
I have a json column in MySQL which contains a list of items for eg.
"style": {"style1", "style2", "style3", "style4", "style5"}
I want to ...
0
votes
1
answer
70
views
Query Optimization | Improve Query Time with LIKE Statement in Use
I have the following query;
SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_varchar` AS `at_url_path_default` ON (`at_url_path_default`.`row_id` = `e`.`...
0
votes
0
answers
207
views
SQL search for a pattern in the middle of a string (infix search) without full table scan
With SQL, I need to select rows which have a pattern like %hello% (i.e. <anything>hello<anything>) in a column, with potentially 100 millions of rows or more.
In the answer Infix search in ...
0
votes
0
answers
740
views
Performance of searching for hex strings in large tables (using LIKE, Full-Text Search, etc.)
I have a table with 40+ million rows in MS SQL Server Express 2019. One of the columns store pure hexadecimal strings (both binary and readable ASCII content). I need to search this table for rows ...
0
votes
1
answer
69
views
duplicate entries from mysql LIKE query
with this sample dataset
I have this query
SELECT products.id,
products.title AS product_title,
products.code,
products....
0
votes
1
answer
383
views
How to search for compound words, and get the word parts returned
I need to be able to search for compound words like "menneskerettighedsforkæmperens" (the human rights activist's) and find the words "menneske" (human), "rettighed" (right) and "forkæmper" (activist)....
0
votes
1
answer
138
views
Match similar special character in filters
I have to perform a search on a table with Turkish city names.
The users would enter the first 4 characters of a city and I need to fetch the results from SQL.
For example, user wants to find the ...