Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT CONCAT(first_name, ' ', last_name) AS full_name, UPPER(email) AS email_upper, SUBSTRING(phone, 1, 3) AS area_code, REPLACE(bio, '<script>', '') AS clean_bio, TRIM(username) AS username_clean FROM users;
Result
Open