Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get last three characters in mysql column

SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY SUBSTRING(NAME,-3), ID;
Comment

PREVIOUS NEXT
Code Example
Sql :: create in sql 
Sql :: t-sql get duplicate rows 
Sql :: purge undo tablespace oracle 11g 
Sql :: foreign key sqlite3 python 
Sql :: create database collation 
Sql :: MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES 
Sql :: sql get month name 
Sql :: how to use a database to see tables mysql 
Sql :: add column not null with default value postgres 
Sql :: replace all numbers in mysql 
Sql :: ubuntu mysql cannot connect to database server remote 
Sql :: select all except one column sql 
Sql :: sql select max value from multiple rows 
Sql :: where date in datetime mysql 
Sql :: postgresql search object in array 
Sql :: postgres type cast to string 
Sql :: mysql version query 
Sql :: insert query return id mysql 
Sql :: flask sqlalchemy filter multiple conditions 
Sql :: show constraints mysql 
Sql :: postgres foreign key multiple columns 
Sql :: postgresql dump and restore db 
Sql :: convert sql to relational algebra 
Sql :: sql trim whitespace 
Sql :: postgresql casting integer to string 
Sql :: apex set debug level 
Sql :: phpmyadmin password root 
Sql :: mysql clear screen 
Sql :: join in update query in mysql 
Sql :: mysql disable query caching 
ADD CONTENT
Topic
Content
Source link
Name
2+3 =