The Joomla JFactory::getDbo() class. An incomprehensible error in the SQL query when reading the table, but where?

Question

PHP

It seems to be a simple request and very simple

$db = JFactory::getDbo();
$db->setQuery( "SELECT * FROM tur_userxtd_profiles WHERE user_id='622' AND key ='BASIC_AVATAR'");

but it throws an error:

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 'key ='BASIC_AVATAR'' at line 1 SQL=SELECT * FROM #__userxtd_profiles 
WHERE user_id='622' AND key ='BASIC_AVATAR'

Below is the table itself It is

possible that I am stupid on the elementary, but? apparently, he didn’t get enough sleep (
I ran the same SQL in the console and bam, the same error. Why do I have the wrong query?

Answer 1

try to escape key

$db->setQuery( "SELECT * FROM tur_userxtd_profiles WHERE user_id='622' AND `key` ='BASIC_AVATAR'");