CREATE PROCEDURE `sp_DBR`(email_to varchar(50), global_filter varchar(50))
BEGIN
declare findme varchar(50) default '%';

IF CHAR_LENGTH(global_filter) >= 1 THEN 
	set findme = concat('%', global_filter, '%');
END IF;

select 	u.id as 'Id',
	u.username as 'Username',
	u.first_name as 'First_name',
	u.last_name as 'Last_name',
	u.email as 'Email',
	from_unixtime(u.last_login) as 'Last login',
	from_unixtime(u.reg_date) as 'Reg date',
	u.organization as 'Organization'
from moodlite.users u
where u.id like findme;

END
$$