Questions tagged [string-searching]
For questions about searching a string for matches
80
questions
0
votes
1
answer
56
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
8
votes
2
answers
1k
views
Fastest way to split/store a long string for charindex function
I have a 1 TB string of digits. Given a 12-character sequence of digits I want to get the start-position of this sequence in the original string (charindex function).
I have tested this with a 1GB ...
CommunityBot
- 1
0
votes
1
answer
7k
views
How can I search for a hex string in oracle?
There's a database record that is incorrect. The name field displays like this in a browser ( this is incorrect ):
Thcˇodore
And when I look at the record via SQL results, I see:
Thc\xCB\x87odore
I'...
CommunityBot
- 1
1
vote
1
answer
2k
views
Compare strings from two tables SQL Server 2014
I'm using these two tables in a SQL Server 2014 database:
CREATE TABLE #FORMULAS
(
[ID] [int] IDENTITY(1,1) NOT NULL,
[DataSourceAddress] [nvarchar](255) NULL,
[Description] [nvarchar](...
- 80.3k
1
vote
2
answers
826
views
Query performance of searching pattern
Posted the same question on SO, but did not get answer.
As per Andrey Nikolov comment, tried with Trigram, but the table name and column(more than 50 columns) are dynamic i mean will get from front ...
CommunityBot
- 1
2
votes
2
answers
3k
views
Return results that contain or do not contain punctuation
Is there a way within MySQL to return results using a LIKE statement that contain or do not contain punctuation characters such as apostrophes and hyphens?
For example if I have one of the following ...
CommunityBot
- 1
4
votes
1
answer
390
views
Find records with same string with extra character
OK, so I have a Microsoft SQL Server 2014 database table called owner with around 90,000 records with owner information, another called vehicle with vehicle information
Owner_Name ...
- 37.6k
0
votes
1
answer
67
views
Which option is better to search in two tables in varchar columns? [duplicate]
I have a performance problem with searching in varchar columns in SQL Server 2016. Considering these tables have plenty of rows, for example 60000 rows each one.
Tables
CREATE TABLE Persons (
...
- 1,111
1
vote
1
answer
284
views
Use extra column to save an unaccented copy of a string instead of using unaccent module [closed]
I am heavily using the unaccent module in a table with 500.000 rows where each row contains proportionally a lot of accented characters.
The issue I am facing is that my queries have become time ...
- 167k
9
votes
5
answers
6k
views
Matching a ] (closing square bracket) with PATINDEX using the "[ ]" wildcard
I am writing a custom JSON parser in T-SQL†.
For the purpose of my parser, I am using the PATINDEX function that calculates the position of a token from a list of tokens. The tokens in my case are all ...
CommunityBot
- 1
2
votes
1
answer
314
views
How to search Query Store for a specific word or command in a query?
I have an Enterprise Edition of SQL 2016 SP1, that has a database with Query Store active.
I want to search for a specific word or command in the saved queries. I have googled around and not seen ...
- 80.3k
1
vote
1
answer
6k
views
Can a Postgres LIKE statement return an exact match?
I'm trying to search a Postgres table using LIKE and %, but the query is not returning results.
The column local_username will contains values formatted like: username@domain.local OR username@domain....
- 3,280
0
votes
1
answer
49
views
TSQL - Finding Similar Values
I have a static table containing filenames (StaticFilesTbl).
Each day a file is sent in that is stored in DailyFilesTbl.
The filenames in DailyFilesTbl will be different from StaticFilesTbl in that ...
- 2,031
2
votes
1
answer
3k
views
Search entire database(210 tables) for a unique Id (PK) and get the table name
Rewritten Question:
I need to look through an entire database, 210 tables for a unique ID that is a number.
I have limited access to my database through things called nodes (Visual programming.)
...
- 22.8k
2
votes
1
answer
2k
views
How do I find a job that sends a specific email?
I had a job sending an irrelevant email to a group of users.
The title of the email was Staging -> [AUPAIR] arrivalDate trigger issue.
When I query the jobs table in the msdb database using the ...
CommunityBot
- 1
20
votes
3
answers
3k
views
What is it called when you search the middle of a string instead of the beginning?
I am trying to polish up my vocabulary to better communicate with my fellow developers. We have several places in the site where we are debating if we should search for a string from the beginning '...
- 60.5k
2
votes
3
answers
3k
views
Using fulltext search to find a sequence of digits
We have a column of ten digit numbers (with leading zeros). We are trying to find rows that have a specific sequence of digits.
For example, all rows containing "5088" in any place in the column.
...
- 42.5k
0
votes
1
answer
2k
views
why my split string functions are not working with large OBJECT_DEFINITION?
I have in one of my databases a stored procedure
called PROCEDURE [repl].[usp_upd_repl_out_application], that is not exactly a very clever stored procedure but it has over 389 lines.
As I need to ...
- 23.6k
5
votes
4
answers
24k
views
ERROR: operator does not exist: text[] ~~ text
We have an easy syntax that allows us to look into an array for a single scalar,
SELECT 'foo' = ANY(ARRAY['foo', 'bar', 'baz']);
We can use the same method to match with LIKE
SELECT 'foobar' LIKE ...
- 36.5k
1
vote
1
answer
3k
views
Using LIKE to search case insensitive over language specific characters (PostgreSQL)
Using a PostgreSQL database (Collation C, Encoding UTF8) we store data from various languages. This means we also get the special characters for free (e.g. Å, å, ...)
Within an application we now ...
- 60.5k
1
vote
1
answer
624
views
Count number of occurrences of a phrase in ntext
I am trying to create a function for counting the number of occurrences of a phrase in a ntext value.
This my function's code:
alter FUNCTION [dbo].[PhraseCounter] ( @pInput NTEXT, @pSearchPhrase ...
- 22.5k
3
votes
3
answers
3k
views
Autocomplete too slow: possible optimizations?
The autocomplete search functionality of my website searches a varchar field which contains the model number of sale items.
This field can contains strings varying from 1 to 75 characters and the ...
CommunityBot
- 1
2
votes
1
answer
2k
views
Search on concatenate columns
I have this :
CREATE TABLE users
(
first_name varchar(60) NOT NULL,
last_name varchar(60) NOT NULL
);
INSERT INTO users
(first_name, last_name)
VALUES
('Sylvia ', 'Hoeks'),
('...
- 78.4k
3
votes
1
answer
222
views
patindex parser
I am trying to parse a string column matching it against several patterns. I have code that does not produce the desired results.
This is a sample table:
-- demo data
IF OBJECT_ID('dbo.Input', 'U') ...
- 22.5k
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 ...
- 29.9k
0
votes
1
answer
72
views
How to fetch records from table which has csv
Please guide me about following case. I need to fetch records from a table which has a column like shown in the picture. I need to fetch records which has 065 and AMT campaigns only.
I tried:
SELECT ...
- 80.3k
3
votes
1
answer
2k
views
Using SELECT within to_tsvector call in CREATE INDEX
I'm attempting to create a GIN index for full-text search on a field that may have text in it that is one of several different languages. The languages are pre-set and we'll know which language we ...
- 60.5k
4
votes
1
answer
2k
views
Alternatives to LIKE and FTS for mid name search
I have a question about what are the alternatives for LIKE '%%' and Full-Text Search when it comes to searching organisation names, firstnames, surnames, etc.
The LIKE '%%' causes table scan, however ...
- 60.5k
2
votes
1
answer
213
views
Good databases for unanchored LIKE condition
Basically I need a database that is good with queries like LIKE %abc%.
I already tried PostgreSQL with GIN indexes and it is very good, but maybe there is something even better? I also tried MongoDB ...
- 60.5k
4
votes
2
answers
88
views
Performing search on a column by query
Up until today I've used LIKE %term% to query for rows on particular column term. Then I've read about FULL TEXT index. And I think I misunderstood how full text index works.
I have an API that ...
- 60.5k