Run, Practice, Share: Your Interactive SQL Playground

Tags: MariaDB 11.4 MariaDB 11.5 MariaDB 10 MariaDB 10 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) SQLite 3 SQLite 3 Preloaded PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 PostgreSQL 16 PostgreSQL 17 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 MS SQL Server 2022 AdventureWorks (ReadOnly) Firebird 4.0 Firebird 4.0 (Employee) Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL

SUBSTRING - Popular snippets

MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY last run: 2025-04-24 12:27:40
37
SELECT SUBSTRING last run: 2023-12-05 09:11:58
36
SELECT SUBSTRING last run: 2023-12-05 09:44:27
31
PostgreSQL 15 CREATE TABLE INSERT INTO MONTH WITH SELECT JOIN SUBSTRING UPDATE CASE AND IN WHERE COUNT NOT last run: 2024-12-04 12:38:44
30
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY SHOW LIKE last run: 2025-04-24 12:27:44
26
PostgreSQL 10 Bookings (ReadOnly) SELECT SUBSTRING JOIN WHERE AND ORDER BY last run: 2024-05-31 06:26:25
26
SELECT SUBSTRING last run: 2023-12-05 09:22:37
26
SELECT SUBSTRING last run: 2023-12-05 09:16:39
25
MS SQL Server 2022 CREATE TABLE INSERT INTO SELECT SUBSTRING last run: 2023-06-05 12:44:26
24
SELECT CONCAT SUBSTRING last run: 2023-12-05 09:24:49
20

SUBSTRING - New snippets

MySQL 8.0 Sakila (ReadOnly) SELECT SUM GROUP BY ORDER BY SUBSTRING SHOW LIKE added at: 2025-04-25 20:14:52
1
MySQL 8.0 Sakila (ReadOnly) SELECT SUM GROUP BY ORDER BY SUBSTRING added at: 2025-04-25 20:14:45
1
MySQL 8.0 Sakila (ReadOnly) SELECT COUNT GROUP BY ORDER BY SUBSTRING SHOW LIKE added at: 2025-04-25 20:13:32
2
MySQL 8.0 Sakila (ReadOnly) SELECT COUNT GROUP BY ORDER BY SUBSTRING added at: 2025-04-25 20:13:30
2
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY SHOW LIKE added at: 2025-04-25 10:01:01
1
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY added at: 2025-04-25 10:00:58
1
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY added at: 2025-04-25 10:00:01
2
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY added at: 2025-04-25 09:59:57
1
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY added at: 2025-04-25 09:59:53
1
MySQL 8.0 Sakila (ReadOnly) SELECT SUBSTRING ORDER BY added at: 2025-04-25 09:59:29
1

SQLize.online - Popular functions

SELECT

1478k

WHERE

812k

ORDER BY

661k

CREATE TABLE

478k

JOIN

467k

INSERT INTO

426k

GROUP BY

392k

AND

357k

325k

PRIMARY KEY

308k

NOT

307k

COUNT

281k

SHOW

255k

WITH

160k

FOREIGN KEY

149k

LEFT

138k

CONSTRAINT

130k

DROP TABLE

115k

AUTO_INCREMENT

111k

INNER JOIN

110k

LENGTH

103k

99k

SUM

99k

DEFAULT

87k

HAVING

82k

UPDATE

68k

57k

BETWEEN

54k

CONCAT

43k

DELETE

41k

CASE

36k

CREATE VIEW

36k

ALTER TABLE

35k

DROP VIEW

27k

REPLACE

26k

ROW_NUMBER

24k

MONTH

24k

CREATE PROCEDURE

23k

EXEC

19k

DROP PROCEDURE

19k

RIGHT

17k

DENSE_RANK

12k

ADD CONSTRAINT

12k

COALESCE

11k

LEAD

11k

LAG

10k

SUBSTRING

10k

CROSS JOIN

OUTER JOIN

CREATE OR REPLACE FUNCTION

INSERT INTO

CREATE FUNCTION

TRUNCATE

ADD COLUMN

DAYOFWEEK

UPPER

SUBSTR

LOWER

DROP COLUMN

DESCRIBE

TRIM

INSERT INTO

LEFT JOIN

IFNULL

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

REVERSE

JSON_ARRAY

JSON_CONTAINS

LPAD

DROP CONSTRAINT

INSERT INTO

855

ORDER BY

750

NULLIF

696

JSON_AGG

640

UUID_GENERATE_V4

624

INNER JOIN

516

INSERT INTO

437

CREATE OR REPLACE TRIGGER

435

GROUP BY

416

ADD CONSTRAINT

403

RTRIM

396

DROP FUNCTION

360

RPAD

262

LTRIM

222

DROP TRIGGER

192

FOREIGN KEY

178

DROP INDEX

176

PRIMARY KEY

153

ROW_TO_JSON

138

CREATE TABLE

132

DROP SEQUENCE

DROP PROCEDURE

ADD COLUMN

INNER JOIN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

SQLize Online / PHPize Online / SQLtest Online

SUBSTRING - Popular snippets

SUBSTRING - New snippets

SQLize.online - Popular functions