|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ivoire'
AND city NOT LIKE '%,%'
AND city NOT LIKE ''
AND city NOT LIKE '%(' at line 2
SELECT count(city),city,pays FROM members
WHERE `pays`='cote_d'ivoire'
AND city NOT LIKE '%,%'
AND city NOT LIKE ''
AND city NOT LIKE '%(%'
AND city NOT LIKE '%/%'
AND city NOT LIKE '%)%'
AND city NOT LIKE '%Ny%'
AND city NOT LIKE '%New yrok%'
AND city NOT LIKE '%Newyork%'
AND city NOT LIKE '%city%'
AND city NOT LIKE '%Nyc%'
AND city NOT LIKE '%any%'
AND city NOT LIKE '%Bkk%'
AND city NOT LIKE '%usa%'
AND city NOT LIKE '%where%'
AND city not REGEXP '^[0-9]*$'
GROUP BY city ORDER by count(city) DESC LIMIT 20
| |