Question : NOTE: The application is not really about websites or keywords, I am using that here only to provide […]
Tag: like
How to filter a character followed by numbers string pattern in PostgreSQL?
Question : Back in SQL Server, I use the command below to get the matching string pattern of #1234 from […]
If in mysql I have string `xxx yyy` – how can I SELECT this if user input `xxxyyy`?
Question : My online-shop in PHP (OpenCart). On site we have product-search. For example product have name iSport 220, and […]
SQL server Like pattern match with CONCAT() always fails
Question : I am facing problem in a simple query script for SQL server. Please help The script is CREATE […]
Postgres won’t use btree index in left-anchored LIKE query [duplicate]
Question : This question already has answers here: Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL (8 […]
SQL QUESTION_Case When + LIKE % [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
SQL regex PostgreSQL
Question : Let’s consider a table like that: id | name 1 | This is a test sentence 2 | […]
How to do a case-insensitive LIKE in a case-sensitive database?
Question : My vendor requires the data warehouse database to be case sensitive, but I need to do case-insensitive queries […]
like in exist() xml mssql
Question : By following question: See if XML element exists at any level in document with a specific value Is […]
Should I use the LIKE predicate or fetch all rows and process them on the client?
Question : I am optimizing my application, while this task, I find one query which is fetching data from database […]