Sql remove leading spaces

SELECT TRIM('   Exemple   ');						-- 'Exemple'
SELECT LTRIM('   Exemple   ');						-- 'Exemple   '
SELECT RTRIM('   Exemple   ');						-- '   Exemple'
SELECT TRIM(BOTH 'x' FROM 'xxxExemplexxx');			-- 'Exemple'
SELECT TRIM(LEADING 'x' FROM 'xxxExemplexxx');		-- 'Exemplexxx'
SELECT LTRIM('xxxExemplexxx', 'x');					-- 'Exemplexxx'
SELECT TRIM(TRAILING 'x' FROM 'xxxExemplexxx'); 	-- 'xxxExemple'
SELECT RTRIM('xxxExemple', 'x');					-- 'Exemplexxx'

Source: sql.sh

Similar codes

0 vote122 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
7 votes134 views2 answers
How to create index mysql
SQL
0 vote121 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
31 votes123 views2 answers
Grant all priviledges to mysql user
SQL
1 vote116 views1 answer
Postgresql contains
SQL
2 votes120 views4 answers
Mysql select into new table
SQL
1 vote154 views4 answers
How to check table in postgresql from terminal
SQL
1 vote116 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote116 views1 answer
How to see all table partition in oracle
SQL
0 vote123 views1 answer
Mysql order by rand limit 1 really slow
SQL