cengizhancaliskan · November 25, 2017 19:58
diff --git a/Slug in MySQL b/Slug in MySQL
 # generate slug
 UPDATE table_name SET slug = replace(trim(lower(name)), ' ', '-');

 # check irregular slug..
 SELECT * FROM table_name WHERE slug NOT RLIKE '^([a-z0-9]+\-)*[a-z0-9]+$';
	# generate slug
	UPDATE table_name SET slug = replace(trim(lower(name)), ' ', '-');

	# check irregular slug..
	SELECT * FROM table_name WHERE slug NOT RLIKE '^([a-z0-9]+\-)*[a-z0-9]+$';