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 vote376 views1 answer
Oracle plsql sleep
SQL
16 votes382 views3 answers
Update table from another table
SQL
13 votes387 views2 answers
Get date from now() mysql
SQL
104 votes575 views2 answers
Like in mysql
SQL
0 vote368 views2 answers
Search stored procedures
SQL
4 votes343 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote360 views3 answers
Group_concat sql server
SQL
1 vote410 views1 answer
Encrypt password postgresql
SQL
0 vote388 views1 answer
Mysql record group by created date count
SQL
0 vote352 views1 answer
Php get closest location by latitude longitude
SQL