mysql中where or cast

来源：互联网发布：sql的update语句编辑：程序博客网时间：2024/06/06 07:50

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

0 0