[SQLize]

Home | About | FAQ | Links | Feedback

Enter MySQL script (temp tables/CRUD allowed, 5 sec / 5MB / 20 rows max):

CREATE TEMPORARY TABLE news (
  id INTEGER AUTO_INCREMENT PRIMARY KEY,
  slug VARCHAR(255) NOT NULL,
  UNIQUE INDEX slug_i (slug)
);

INSERT INTO news (slug) VALUES
  ('some-really-interesting-article'), ('another-really-interesting-article'),
  ('some-really-interesting-article-2'), ('some-really-interesting-article-3'),
  ('a-boring-article'), ('another-boring-article'), ('some-silly-article'),
  ('some-really-interesting-article-4'), ('some-really-interesting-article-about-stuff'),
  ('yet-another-boring-article'), ('some-silly-stuff'), ('some-really-silly-stuff');

-- Uncomment this to see what happens if you try to insert a duplicate key:
-- INSERT INTO news (slug) VALUES ('some-really-interesting-article');

-- Comment out the EXPLAIN to see the results; try removing either the LIKE or the
-- RLIKE to see how they affect the results and the number of rows considered.
EXPLAIN
SELECT * FROM news
WHERE slug RLIKE 'some-really-interesting-article(-[0-9]+)?$'
  AND slug LIKE 'some-really-interesting-article%';

| (permalink: EQmMF20IEb) Sample 1 | Sample 2

No results are displayed if 5 second timeout reached.

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	news	range	slug_i	slug_i	257		4	Using where

(1 rows returned)