MYSQL: SELECT Method - but don't show duplicates / GROUP or DISTINCT?
Posted
by elmaso
on Stack Overflow
See other posts from Stack Overflow
or by elmaso
Published on 2010-04-05T23:10:30Z
Indexed on
2010/04/05
23:13 UTC
Read the original article
Hit count: 230
hello, how can I Select and dont'show duplicates? actually it's showing like that: apple | apple | apples | apple
this is my code:
$search = $_GET['q'];
$query = "SELECT * FROM query WHERE searchquery LIKE '%$search%' AND searchquery <> '$search'";
© Stack Overflow or respective owner