mysqlregexmysql-udf

preg_rlike not matching characters like ò , í , è etc

Can you hep me to match special characters like ò , í , è with mysql preg_rlike

select first_name from authors where preg_rlike('/Jòse/i',authors.first_name);

It will not retrieve data even if the database has value.

We can handle this with LIKE but I have many like Jòse|Jose|James

Let me please know how can we handle this.

Solution

  • Thanks for your comments

    I got answer to this question either by making the table or just that field is UT8 encoded or using CONVERT(field_name USING utf8) in the query