ThinkPHP/---SQL查重

SELECT userid as 会员编号,usercode as 手机,ucname as 天机会帐号,username as 用户名,star_name as 星名,star_time as 注册时间 from user where FIND_IN_SET(star_name,'北极星,启明星,周星,天佑星,天机星,天王星,天玑星,太白金星,幸福,幸运星,开阳星,星星星星,朝阳,木星,水星,琳星,织女星,花,金星') ORDER BY star_name ASC;

posted @ 2019-02-16 16:15  Gupq  阅读(290)  评论(0编辑  收藏  举报