搜索“إ”字符并返回包含“ا”或“أ”或“إ”char的所有单词？ [关闭]

Question

In Arabic language there are some character the public people can may way for example character ا can be written by one of these (أ,إ,ا) and character ه can be written by one of these (ه, ة) and so on.

for more clarify: may user search the keyword ايمان I will return all results like ايمان or أيمان or إيمان, and if he search for إيمان I will return also the same three words, and if he search for أيمان I will return also the same three words.

I want if user search of one of them (أ,إ,ا) return all words which contain any one of them

Answer 1

I found the answer:

first I replace all similar chars to one char in search keyword by php like this:

$keyword = str_replace('أ', 'ا', $keyword);
    $keyword = str_replace('إ', 'ا', $keyword);
    $keyword = str_replace('ى', 'ي', $keyword);
    $keyword = str_replace('ة', 'ه', $keyword);

then I replace column value stored in database in where sentence like this:

->whereRaw(" (REPLACE(REPLACE(REPLACE(REPLACE(page_title_ar, 'ة', 'ه'), 'أ', 'ا'), 'إ', 'ا'), 'ى', 'ي') like '%" . $keyword . "%' OR "
    . "REPLACE(REPLACE(REPLACE(REPLACE(page_summery_ar, 'ة', 'ه'), 'أ', 'ا'), 'إ', 'ا'), 'ى', 'ي') like '%" . $keyword . "%' OR "
    . "REPLACE(REPLACE(REPLACE(REPLACE(page_content_ar, 'ة', 'ه'), 'أ', 'ا'), 'إ', 'ا'), 'ى', 'ي') like '%" . $keyword . "%' OR "
    . "REPLACE(REPLACE(REPLACE(REPLACE(page_title_en, 'ة', 'ه'), 'أ', 'ا'), 'إ', 'ا'), 'ى', 'ي') like '%" . $keyword . "%' OR "
    . "REPLACE(REPLACE(REPLACE(REPLACE(page_summery_en, 'ة', 'ه'), 'أ', 'ا'), 'إ', 'ا'), 'ى', 'ي') like '%" . $keyword . "%' OR "
    . "REPLACE(REPLACE(REPLACE(REPLACE(page_content_en, 'ة', 'ه'), 'أ', 'ا'), 'إ', 'ا'), 'ى', 'ي') like '%" . $keyword . "%'"
    . " ) and deleted <> 1")

and the problem