MariaDB [test]> show create table foo\G

*************************** 1. row ***************************

       Table: foo

Create Table: CREATE TABLE `foo` (

  `foo_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `foo_dat` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`foo_dat`)),

  PRIMARY KEY (`foo_id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

1 row in set (0.000 sec)

MariaDB [test]> SELECT * FROM foo;

+--------+--------------------------+

| foo_id | foo_dat                  |

+--------+--------------------------+

|      1 | {"A": 1, "C": 3, "B": 2} |

|      2 | {"A": 7, "C": 9, "B": 8} |

+--------+--------------------------+

2 rows in set (0.000 sec)

MariaDB [test]> SELECT * FROM foo WHERE JSON_CONTAINS(foo_dat, '{"A": 1, "B": 2, "C": 3}');

+--------+--------------------------+

| foo_id | foo_dat                  |

+--------+--------------------------+

|      1 | {"A": 1, "C": 3, "B": 2} |

+--------+--------------------------+

1 row in set (0.000 sec)

MariaDB [test]> SELECT foo_id FROM foo WHERE

    ->      JSON_CONTAINS(foo_dat, '{"A": 1, "B": 2, "C": 3}')

    ->  AND JSON_CONTAINS('{"A": 1, "B": 2, "C": 3}', foo_dat);

+--------+

| foo_id |

+--------+

|      1 |

+--------+

1 row in set (0.000 sec)