Sql

SELECT LEFT(title , 10) FROM articles;

#get first 10 chars of string
SELECT SUBSTRING(subject, 1, 10) FROM tbl

PREVIOUS	NEXT

Code Example
Sql :: sql select case when
Sql :: creating index in mysql
Sql :: round in sql server
Sql :: xampp mysql version
Sql :: change magento database url usimg musql
Sql :: add multiple row table pl sql
Sql :: json with root element in sql server
Sql :: rename table sqlite
Sql :: where with multiple conditions in mongodb
Sql :: create table in sql server
Sql :: postgres user permissions
Sql :: como consultar registros duplicados en mysql
Sql :: find usage of table in sql server
Sql :: sql replace single quote
Sql :: mysql load sql from file
Sql :: calculate percentage in sql
Sql :: drop CHECK constraint sql
Sql :: tinydb add table
Sql :: SQL Add Column in a Table
Sql :: sql alter table order by
Sql :: sql joins
Sql :: how insert auto increment
Sql :: mysql show create table
Sql :: postgres order by month
Sql :: command to give readonly access to a postgres sql user
Sql :: run function in sql
Sql :: sqlite3 pragma foreign keys
Sql :: mysql select latest entry by time
Sql :: mysql if statement
Sql :: insert query in sql