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

Filed under:
|
|
|

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

Related posts about mysql

Related posts about select