mysql中where or cast

最新推荐文章于 2024-06-03 00:49:12 发布

HackProgramer

最新推荐文章于 2024-06-03 00:49:12 发布

阅读量1.4k

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/HackProgramer/article/details/34796205

版权

Mysql 专栏收录该内容

53 篇文章 0 订阅

订阅专栏

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 '%洗%';