Questions tagged [string-searching]
For questions about searching a string for matches
13
questions with no upvoted or accepted answers
2
votes
0
answers
140
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 ...
- 493
2
votes
0
answers
45
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"
}...
- 121
2
votes
0
answers
44
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 ...
- 21
1
vote
0
answers
393
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"
...
- 11
1
vote
0
answers
69
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,
...
- 119
1
vote
0
answers
63
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 ...
- 189
1
vote
1
answer
294
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)....
- 11
1
vote
1
answer
656
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 ...
- 111
0
votes
0
answers
150
views
Is instant text search possible in big table with HTMLs?
I have a pretty big table with HTMLs (about 500K rows, average length of text is ~150K).
It is required to make fast search (less than 1s) rows which match let say '%<meta name="twitter:app%'.
...
0
votes
0
answers
377
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 ...
- 131
0
votes
1
answer
48
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....
- 33
0
votes
1
answer
124
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 ...
- 113
-2
votes
0
answers
24
views
How to extract specific numbers from a string?
I have a field holding strings like this - "1,2,3,4,5,11,21,22,10" [each record contains a combination of figures from 1 to 20 separated by commas]
I need to extract only the records ...
