79623754

Date: 2025-05-15 15:51:32
Score: 1
Natty:
Report link

Without regular expression, but you are turning the logic around to make use of the % wildcard in LIKE. I think this is pretty close to the logic that you had in mind.

SELECT DISTINCT(CITY)
FROM STATION
WHERE 'aeiou' LIKE CONCAT( "%",LEFT(CITY, 1),"%")
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Roman Ruzica