i have problem in search
arabic letter have different shapes for one letter like
أ إ ا
ي ى
ه ة
all these letters have different unicode
i want to union search when enter letter like (ا)the query must get all word contain
all other shape of (ا) (أ-إ-ا)
i make input field with id search
$search = $_POST['search'];
$stmt = $con->prepare("select * from `newdrs`
INNER JOIN `district` ON newdrs.prosec=district.DistCode
INNER JOIN `case_kind` ON newdrs.case_kind=case_kind.id
where accused_names like'%$search%' ");
$stmt->execute();
$employee_details = $stmt->fetchAll(PDO::FETCH_ASSOC);
i want to search with one letter shapes and get all other shame
أحمد
احمد
إحمد