<?php $email = "MyEmail@mysite.ru"; if (preg_match("/^(?:[a-z0-9]+(?:[-_.]?[+a-z0-9]+)?@[a-z0-9_.-]+(?:\.?[a-z0-9]+)?\.[a-z]{2,5})$/i", $email)) { echo "Адрес указан корректно."; } else { echo "Адрес указан не правильно."; } ?> SELECT ws.Name as 'Название сервиса', us.Email, ub.StateVal, ub.BindKey FROM [IMKORelease].[dbo].[user_User] us
inner join [IMKORelease].[dbo].[wapi_UserBind] ub on us.UserId = ub.UserId
inner join [IMKORelease].[dbo].[wapi_Service] ws on ws.ServiceId = ub.ServiceId
where us.Email like '%<Почта клиента>%' |