Cacher is the code snippet organizer for pro developers

SELECT
	wp_redirection_items.*,
	wp_redirection_groups.position AS group_pos
FROM wp_redirection_items
INNER JOIN wp_redirection_groups ON
	wp_redirection_groups.id=wp_redirection_items.group_id
	AND wp_redirection_groups.status='enabled'
	AND wp_redirection_groups.module_id RLIKE 'd'
WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url RLIKE '\/$')



17154
  105
17259


/* SELECT
	wp_redirection_items.*
FROM wp_redirection_items */
UPDATE wp_redirection_items
SET url = REPLACE( url, '/nate', '')
	regex = 1
WHERE url NOT REGEXP '/$'



/* UPDATE wp_redirection_items
SET url = CONCAT( url, '[/]?') */
WHERE url NOT REGEXP '/$'