Sql

SELECT LEFT(title , 10) FROM articles;

SELECT author FROM lyrics WHERE author LIKE 'B%';

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

PREVIOUS	NEXT

Code Example
Sql :: pdo mysql insert
Sql :: sql first day of current year
Sql :: .... ERROR! The server quit without updating PID file mysql centos
Sql :: mysql add column if not exists
Sql :: oracle list packages
Sql :: how to stop all connections to a psql 12 database?
Sql :: see mysql users ubuntu
Sql :: python sqlite3 create table if not exists
Sql :: mysql first day of month
Sql :: alter table delete column
Sql :: created at and updated at in mysql
Sql :: sql error 1175
Sql :: no data found oracle
Sql :: sql between date range
Sql :: how to change table name in sqlite
Sql :: su: Authentication failure mysql
Sql :: sql padd let with zeros
Sql :: generate c# class from sql server table
Sql :: install mysql workbench ubuntu 20.04 terminal
Sql :: stop psql server windows
Sql :: how to add auto increment primary key
Sql :: mysql dump mysql db cli
Sql :: show sqlite column names
Sql :: mysql add column default value
Sql :: left join with only first record
Sql :: oracle kill session by sql_id
Sql :: scaffold npgsql net core
Sql :: mysql show carset
Sql :: show table columns
Sql :: drop table if exists oracle