mysql中where or cast

关注

原创最新推荐文章于 2026-03-22 00:38:46 发布 1.5k 阅读 AI 写同款· GEO 优化 ›

一文读懂 SAP ERP / SAP S/4HANA 里的 Price List：概念、配置、定价流程与可运行 ABAP 示例 SAP ERP/S4HANA中的Price List解析本文系统阐述了SAP定价体系中Price List的核心概念和实现机制。Price List并非独立的价目表，而是通过条件技术(条件类型、访问序列、条件记录)与Price List Type(PLTYP)共同作用的定价维度。文章详细说明了： Price List本质上是客户主数据中的PLTYP字段，作为定价查找键使用定价流程中条件访问序列如何利用PLTYP查找特定价格 S4HANA与ECC版本在价格维护入口的差异实际业务中如何通过不同PLTYP实阅读详情

SELECT
*
FROM
`xilian168`.`member_store`
WHERE
CAST(
`xilian168`.`member_store`.`name` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`contact` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`phone` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`address` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`description` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`keywords` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`remark` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`icon` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`x` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`y` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`fav_info` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%'
OR CAST(
`xilian168`.`member_store`.`intro` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci LIKE '%洗%';

收录于