How to Write mysql Select LIKE cause in php -

how write mysql query,

select *  `content`where  `language_option_tag`  "%english%"  

into php code select data user have been post form

$sql .= 'select *  `content`  `language_option_tag` "%' .$lang_name. '%" ;  

$lang_name = $_post['your_lang'];     $sql = "select * content `language_option_tag` '%$lang_name%'" ;