Use the CASE conditional operator in queries|V4.6.3|OceanBase AI Database|docs|OceanBase Documentations