The order by seems to work ok for me - may need to add a disclaimer saying they need to put whatever they are looking for in between the %% where you have the term in order to return it (some people may not know SQL).
Otherwise you could just change the line
AND up.website ILIKE :url
to
AND up.website IS NOT NULL
To return all profiles with a webaddress.