fetch all information from 4 tables using mysql query

please help me :

I want fetch all rows that match by keyword using %LIKE% but fetch from 4 tables in one query.