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▸▸▸

Tips for Querying a MySQL Database

February 20, 2015

ORDER BY nach Prioritaet

code

SELECT * FROM countries
ORDER BY iso_code IN ('UK','US') DESC, iso_code;

Booleans werden als 0/1 sortiert.

NOT LIKE und NULL

Wenn Spalten NULL sein koennen:

code

SELECT count(*)
FROM runs
WHERE info IS NULL OR info NOT LIKE '%wrong%';

Klammern bei komplexen WHERE

code

WHERE (
  CompanyName LIKE '%q%'
  OR description LIKE '%q%'
  OR KeywordTags LIKE '%q%'
)
AND Active='yes'
AND State='Florida'