thinkphp之进阶sql语法,持续更新

数据去重

//过滤id相同的数据
$Model->field(‘id,name’)->group(‘id’)->select();
sql: select id,name from user group by name;

随机取几条数据

$Model->limit(3)->order(‘rand()’)->select();
sql: select * from user order by rand();

获得数据字段名字相同的字段及数量

$Model->field(‘text,count(text) as text_count’)->group(‘text’)->select();
sql:select text,count(text) as text_count from 表 group by text;

如果您觉得本篇对你有帮助,可以点关注,给个赞,支持一下,过程有遇到什么问题也欢迎评论私信,进行交流