sql - LIKE 表达式的左侧必须计算为 varchar 吗？

Question

我正在根据字段内的字符串编写带有过滤器的查询。但是，我正在运行查询它显示错误:

Left side of LIKE expression must evaluate to a varchar

我希望所有购买宝马的人都基于 custom_field fFilter .

这是自定义字段内的示例数据:

{ "car_model;":"BMWZ4", "car_id":"0980291", "manufacture":"bmw" }

代码:

SELECT
    first_name,
    Last_name,
    country,
    custom_field
FROM 
    sales_table
WHERE 
    custom_field LIKE '%BMWZ4%' 

预期结果

first_name: John   
last_name: Parker      
country: Germany   
custom_field: {"car_model;":"BMWZ4","car_id":"098222291","brand":"bmw"}

Answer 1

SELECT
first_name,
Last_name,
country,
custom_field
FROM sales_table
WHERE cast( custom_field as varchar(max)) LIKE '%BMWZ4%'