12 2016 档案

MYSQL常用函数
摘要：1.Mysql字符串字段判断是否包含某个字符串FIND_IN_SET SELECT * FROM qr_usercontacts WHERE EXISTS(SELECT touristorder_ref_userids FROM qr_touristorder WHERE touristorder_ 阅读全文

posted @ 2016-12-09 16:38 剑舞江南 阅读(113) 评论(0) 推荐(0) 编辑

MYSQL CASE WHEN THEN END 用法
摘要：SELECT qr_cash_record.*,CASE WHEN cashrecord_type = 3 THEN (SELECT product_title FROM qr_fundsupport LEFT JOIN qr_fundplan ON fundplan_id = fundsuppor 阅读全文

posted @ 2016-12-06 17:44 剑舞江南 阅读(432) 评论(0) 推荐(0) 编辑