How to select json in MySQL?

[lz1998]

SELECT * FROM muscleape WHERE category->'$.id' = 1;

[billy1624]

Hi @lz1998, we don't have native support for it but you could do it like below.

use sea_query::Expr;

assert_eq!(
    cake::Entity::find()
        .filter(Expr::cust("category->'$.id' = 1"))
        .filter(Expr::cust("category->'$.id'").equals(Expr::val(1)))
        .build(DbBackend::MySql)
        .to_string(),
    "SELECT `cake`.`id`, `cake`.`name` FROM `cake` WHERE category->'$.id' = 1 AND category->'$.id' = 1"
);

[joebnb]

is there still not support json query?

[joebnb]

if it was supported，please update sea-orm docs，this function is helpful when using postgresql