DWQA Questions › Query for mysql concat() in WHERE clause? 0 Vote Up Vote Down sql asked 5 years ago select * from `targets` where concat_ws(‘ ‘,first_name,last_name) like ‘%an%’