SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS Palindromes; CREATE TABLE Palindromes ( id INT PRIMARY KEY AUTO_INCREMENT, english VARCHAR(40), russian VARCHAR(40) ); INSERT INTO Palindromes(english, russian) VALUES ('hut', 'шалаш'), ('rotor', 'ротор'), ('tenet', 'принцип'), ('radar', 'радар'), ('flood', 'потоп'), ('level', 'уровень'), ('madam', 'мадам'), ('deed', 'поступок'), ('it', 'оно'), ('kayak', 'каяк'); SELECT english, russian FROM Palindromes WHERE english = reverse(english) AND russian=reverse(russian) ORDER BY english --LIMIT 3