MYSQL:SELECT方法-但不显示重复项/GROUP或DISTINCT? [英] MYSQL: SELECT Method - but don't show duplicates / GROUP or DISTINCT?

问题描述

如何选择但不显示重复项? 实际上，它是这样显示的:apple |苹果|苹果|苹果

How can I select and don't show duplicates? Actually, it's showing like that: apple | apple | apples | apple

这是我的代码:

$search = $_GET['q'];
$query = "SELECT * FROM query WHERE searchquery LIKE '%$search%' AND searchquery <> '$search'"; 

推荐答案

您已经说了一个神奇的词:DISTINCT.

You already said the magic word: DISTINCT.

SELECT DISTINCT columnname
FROM query
WHERE ....

请注意，如果使用SELECT DISTINCT *，则可能无法使用，因为当您选择*时，这意味着选择所有列，包括具有唯一约束(例如主键)的列.仅选择您需要的列-一般远离*，尤其是在使用DISTINCT时.

Note that it probably won't work if you use SELECT DISTINCT * because when you select * that means select all columns, including columns which have a unique constraint such as the primary key. Only select the columns you need - stay away from * in general, and especially so when using DISTINCT.

这篇关于MYSQL:SELECT方法-但不显示重复项/GROUP或DISTINCT?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！