-- Syntax SELECT substring_index(substring_index(field_name, 'initial_limit_chars', -1), 'final_limit_chars', 1) FROM table; -- Example value in field "url": contract=1234567890123350566076070666&issued=2023/07/15 SELECT substring_index(substring_index(url, 'contract=', -1), '&issued=', 1) FROM table; -- Result: 1234567890123350566076070666