TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸
← databases

Search for characters in SQL with LIKE and CONTAINS

November 30, 2017

LIKE (Standard)

  • % = beliebig viele Zeichen
  • _ = genau ein Zeichen
code
SELECT * FROM table WHERE column LIKE 'test';
SELECT * FROM table WHERE column LIKE 'test%';
SELECT * FROM table WHERE column LIKE '%test';
SELECT * FROM table WHERE column LIKE '%test%';

Beispiele:

code
SELECT * FROM table WHERE column LIKE '_r%';
SELECT * FROM table WHERE column LIKE 'a%o';

CONTAINS (DB-spezifisch)

CONTAINS() ist nicht Standard-SQL. Funktioniert je nach DB (z. B. SQL Server Full-Text).

code
SELECT * FROM table WHERE CONTAINS(column, 'test');

In MySQL ist CONTAINS() fuer Full-Text anders (MATCH/AGAINST).

Mehrere Begriffe

OR:

code
WHERE column LIKE '%word1%'
   OR column LIKE '%word2%';

AND:

code
WHERE column LIKE '%word1%'
  AND column LIKE '%word2%';

Links