[SOLVED] 'Case' in CB query

What wrong in may query!?

SELECT CASE WHEN cb_towncheck='Other' THEN city ELSE cb_towncheck END CASE FROM `znaji_comprofiler` WHERE user_id ='[user_id]'

Enable debug mode and maximum error reporting in Joomla global configuration. Then visit the page it's supposed to be enabled on and it'll error out if there's an error in the query. Also test within your database directly using phpmyadmin (replacing [user_id] with an ID to test) and see if it works as expected.

That's true....
#1064 - 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 'CASE FROM `znaji_comprofiler` WHERE `user_id` ='266' LIMIT 0, 30' at line 1


Can you halp me!?
How can I make a query with CASE!? Example?

Please see the below MYSQL documentation regarding case.

CASE:
dev.mysql.com/doc/refman/5.6/en/case.html

Usage of CASE in SELECT:
dev.mysql.com/doc/refman/5.6/en/control-flow-functions.html

General SQL Tutorials:
www.w3schools.com/sql/default.asp

You're probably better of using IF statements instead of CASE, which you can find an example of in my second link above.

Thank you Krileon!!!!!!

This is query work correctly:

SELECT if(cb_towncheck='Иное', city, cb_towncheck) FROM `znaji_comprofiler` WHERE user_id ='[user_id]'