mysql中sql语句字段如何拼接成字符串的方法
CONCAT函数
select CONCAT('My', 'S', 'QL');
效果图如下:
拼接字段
SELECT province,city ,CONCAT(province,city) as province_city FROM `qipa_member_addr` where consignee_addr !='' order by id desc
效果图如下:
指定字段consignee_addr 地址详情和省份城市拼接的字符串CONCAT(province,city) 比较
SELECT province,city ,CONCAT(province,city) as province_city ,consignee_addr FROM `qipa_member_addr` where consignee_addr !='' and consignee_addr = CONCAT(province,city) order by id desc