Replace persian character before search php mysql

mysql_query_persian.md

SELECT * FROM table_name WHERE column_name LIKE '%ا%' OR column_name LIKE '%آ%';

SELECT * FROM table_name WHERE column_name REGEXP '[اآ]';

SELECT * FROM table_name WHERE REPLACE(column_name, 'آ', 'ا') LIKE '%ا%';

SELECT * FROM table_name WHERE column_name COLLATE utf8_persian_ci LIKE '%ا%';