Select user_id id , u_name username, f_name firstname,
l_name lastname , email email  from <@PREFIX@>jshopping_users

where (user_id like :Klantid or u_name like :gebruikersnaam or f_name like :voornaam
or l_name like :achternaam or email like :email )

limit 10