Question : I have several rows with a lot of content and i’m trying to find some code and extract […]
Tag: string-searching
Use extra column to save an unaccented copy of a string instead of using unaccent module [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
How to do a ranked search based on number of multiple columns matched
Question : Context I am trying to create a ranked-customer-search that will order results based on “most likely correct”. We […]
LEFT vs CHARINDEX for matching the start of a string in T-SQL
Question : I want to match the beginning of a string in a WHERE clause. While I recognise that so […]
Can a Postgres LIKE statement return an exact match?
Question : I’m trying to search a Postgres table using LIKE and %, but the query is not returning results. […]
How to select values consisting of numerals only?
Question : I have a column like this: WW0476091 YA0457514 547856232 856987452 254785W11 I want to get the values that […]
How to optimize query for text array in PostgreSQL using `@>` operator
Question : I have a column of type text[] and I want to search over this column using this SQL […]
Query performance of searching pattern
Question : Posted the same question on SO, but did not get answer. As per Andrey Nikolov comment, tried with […]
Search string data with special characters removed
Question : We have a table with ~6 million of products: ID Name Code 1 One 123.456.789-M 2 Two 852.789456 […]
patindex parser
Question : I am trying to parse a string column matching it against several patterns. I have code that does […]