SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tbl (val varchar(64)); INSERT INTO tbl VALUES ('a111'),('b111'),('c222'); SELECT count(*) AS counts FROM tbl WHERE val LIKE '%111%' OR val LIKE '%222%'; SELECT count(*) AS counts_all, count(NULLIF(val LIKE '%111%', 0)) AS counts_111, count(NULLIF(val LIKE '%222%', 0)) AS counts_222 FROM tbl WHERE val LIKE '%111%' OR val LIKE '%222%' ; SELECT query, COUNT(*) cont FROM ( SELECT CASE WHEN val LIKE '%111%' THEN '%111%' WHEN val LIKE '%222%' THEN '%222%' ELSE 'other' END query FROM tbl WHERE val LIKE '%111%' OR val LIKE '%222%' ) tbl GROUP BY query; ;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear