I want to search user in full name column or username column. And also i confuse how to add variable ‘param_user’ in string quote.
... WHERE (LOWER(profile.full_name) ILIKE '%:param_user%') OR (profile.username ILIKE '%:param_user%');
I want to search user in full name column or username column. And also i confuse how to add variable ‘param_user’ in string quote.
... WHERE (LOWER(profile.full_name) ILIKE '%:param_user%') OR (profile.username ILIKE '%:param_user%');