LIKE sql on 2 fields?

Question

PHP

Hello, tell me how to make a search on 2 fields with LIKE?

SELECT * FROM users WHERE email,name LIKE '%checn%'

doesn't work, syntax error..

Answer 1

email LIKE '%checn%' OR name LIKE '%checn%'
or
CONCAT_WS(' ', email, name) LIKE '%checn%'

Answer 2

SELECT * FROM users WHERE email  LIKE '%checn%' and name LIKE '%checn%'

and so?