Skip to content

Instantly share code, notes, and snippets.

@IndigoW0lf

IndigoW0lf/MySQL substr method

Created March 30, 2022 13:48
Show Gist options
  • Save IndigoW0lf/f42c8c5c53347682beb8a8037535d2c5 to your computer and use it in GitHub Desktop.
Save IndigoW0lf/f42c8c5c53347682beb8a8037535d2c5 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL substr method
Raw
MySQL substr method
SELECT name FROM students
WHERE marks > 75
ORDER BY substr(name, -3, 3), id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment