Been trying for a few hours now to get the distinct function to work with this sql code and its just doesnt seem to want to work, so I need help.
SELECT * FROM uni WHERE name LIKE (:keyword) ORDER BY name ASC LIMIT 0, 15
Been trying for a few hours now to get the distinct function to work with this sql code and its just doesnt seem to want to work, so I need help.
SELECT * FROM uni WHERE name LIKE (:keyword) ORDER BY name ASC LIMIT 0, 15
Got it,
Its for a google style json recommendations that changes when you enter in different items
SELECT DISTINCT uni FROM name WHERE uni LIKE (:keyword) ORDER BY uni ASC LIMIT 0, 15