Back Home
  • Examples
  • Sample Database
#1
SELECT TRIM(' MySQL TRIM Function ');
#2
SELECT TRIM(LEADING FROM '    MySQL TRIM Function   ');
#3
SELECT TRIM(TRAILING FROM '    MySQL TRIM Function   ');
#4
SELECT LTRIM('  MySQL LTRIM function');
#5
SELECT RTRIM('MySQL RTRIM function   ');
Table List
customers
SELECT * FROM customers;
employees
SELECT * FROM employees;
offices
SELECT * FROM offices;
orderdetails
SELECT * FROM orderdetails;
orders
SELECT * FROM orders;
payments
SELECT * FROM payments;
productlines
SELECT * FROM productlines;
products
SELECT * FROM products;
  • SQL Query
Execute
Clear Beautify Minify
  • Result