Top "Sql-like" questions

HQL like operator for case insensitive search

I am implementing an autocomplete functionality using Jquery, when I type the name, it fetches the record from the db, …

spring hibernate spring-mvc sql-like

Which is faster — INSTR or LIKE?

If your goal is to test if a string exists in a MySQL column (of type 'varchar', 'text', 'blob', etc) …

mysql sql-like

How do I perform a case-sensitive search using LIKE?

I'm trying to find records that contain a string of 6 or more alpha-numeric characters in uppercase. Some examples: PENDING 3RDPARTY …

sql-server-2008 pattern-matching sql-like collate

How to search millions of record in SQL table faster?

I have SQL table with millions of domain name. But now when I search for let's say SELECT * FROM tblDomainResults …

sql query-optimization sql-like

Python String Formats with SQL Wildcards and LIKE

I'm having a hard time getting some sql in python to correctly go through MySQLdb. It's pythons string formatting that …

python sql format sql-like

T-SQL - How to escape a slash / in square brackets in LIKE clause

I'm trying to use T-SQL LIKE against multiple values. After my research, the easiest way seems to be something similar …

sql-server tsql escaping sql-like slash

LIKE with integers, in SQL

Can I replace the = statement with the LIKE one for the integers ? by eg. are the following the same thing: …

sql sql-server sql-server-2005 sql-like

SQL Server searching for text in a column

I'm confused over what to use? Basically I need to have a search string that can search a single column …

sql-server full-text-search contains sql-like patindex

LIKE and NULL in WHERE clause in SQL

I have a store procedure which i have planned to use for search and get all values. Scenario: If the …

sql sql-server sql-server-2008 where-clause sql-like

Mysql: Order by like?

assume that we are performing search using keywords: keyword1, keyword2, keyword3 there are records in database with column "name": 1: John …

mysql sql sql-order-by sql-like