If you want to search for any inclusion in a value then you just need to wrap your argument with '%' characters.
SET @name1 = '%' + @name1 + '%'
SET @mob_no = '%' + @mob_no + '%'
SET @emailid = '%' + @emailid + '%'
SET @username = '%' + @username + '%'
SELECT profile.name1 AS name, profile.address, profile.mob_no, profile.emailid, login.username
FROM profile INNER JOIN
login ON profile.log_id = login.log_id
WHERE profile.name1 LIKE @name1
OR profile.mob_no LIKE @mob_no
OR profile.emailid LIKE @emailid
OR login.username LIKE @username