What is the usage of distinct in thinkphp

In thinkphp, the distinct() method is used to remove duplicate values ​​and can return unique values. The parameter of the distinct method is a Boolean value, and the syntax is "$Model->distinct(Boolean parameter )->field('name')->select();".

The operating environment of this article: Windows 10 system, ThinkPHP version 5, Dell G3 computer.

What is the usage of distinct in thinkphp

The purpose of distinct() in TP is mainly to remove duplicate values

The DISTINCT method is used to return the only different value.

$Model->distinct(true)->field('name')->select();

The generated SQL statement is:

SELECT DISTINCT name FROM think_user

The example is as follows:

The display is like this

If you add distinct:

The displayed result is

below Recommended study for the posted code

$offernum = M('offer')->distinct(true)->where('order_id='.$order_id)->field('user_id,number')->select();
dump($offernum);

: "PHP Video Tutorial"

The above is the detailed content of What is the usage of distinct in thinkphp. For more information, please follow other related articles on the PHP Chinese website!