MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT VERSION();


VERSION()


8.0.30


SET @`saved_stuff` := '{"34f8d790-6e25-4f31-ae8a-a17c04c96045": 1}';
SELECT
  JSON_EXTRACT(
    @`saved_stuff`,
    '$."34f8d790-6e25-4f31-ae8a-a17c04c96045"'
  ) IS NOT NULL;


JSON_EXTRACT(
    @`saved_stuff`,
    '$."34f8d790-6e25-4f31-ae8a-a17c04c96045"'
  ) IS NOT NULL


1


SELECT
  JSON_EXTRACT(
    @`saved_stuff`,
    '$.34f8d790-6e25-4f31-ae8a-a17c04c96045'
  ) IS NOT NULL;