MySQL Query : SELECT * FROM v9_picture WHERE status=99 AND catid IN (20,21,22,23) and city<>'' GROUP BY substring_index(city,' -',1) having city is not null and city<>'' LIMIT 20 MySQL Error : Unknown column 'city' in 'where clause' MySQL Errno : 1054 Message : Unknown column 'city' in 'where clause' Need Help?
