mysql中where or cast

最新推荐文章于 2025-05-27 16:32:54 发布

原创最新推荐文章于 2025-05-27 16:32:54 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

53 篇文章

订阅专栏

本文提供了一个SQL查询示例，展示了如何从数据库表中通过模糊匹配筛选含有特定字符的数据记录。

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