CREATE TABLE users (
user_id INT AUTO_INCREMENT PRIMARY KEY,
user_firstname VARCHAR(100) NOT NULL,
user_surname VARCHAR(100) NOT NULL,
user_telephone VARCHAR(20),
user_email VARCHAR(100)
);
INSERT INTO users (user_firstname, user_surname, user_telephone, user_email) VALUES
('Alice', 'Smith', '123-456-7890', 'alice.smith@example.com'),
('Bob', 'Jones', '987-654-3210', 'bob.jones@example.com'),
('Charlie', 'Brown', '555-123-4567', 'charlie.brown@example.com'),
('David', 'Smith', '111-222-3333', 'david.smith@example.com'),
('Eve', 'Adams', '444-555-6666', 'eve.adams@example.com');
SELECT CONCAT(user_firstname, '.', user_surname) AS name, `user_id`, `user_telephone`, `user_email`
FROM `users`
WHERE `name` = 'bob.jones'