Error in Selection Query
SELECT,a.ad_title,a.ad_image,a.ad_description, as cate_id,b.cate_name, AS subcateId,c.sub_name, AS ctyName,DATE_FORMAT(a.created_on,'%a., %b %D, %Y') AS createdon FROM tbl_postads as a LEFT JOIN tbl_category as b ON AND b.status='Active' LEFT JOIN tbl_subcategory as c ON AND c.status='Active' LEFT JOIN tbl_state AS s ON = a.state_id AND s.status = 'Active' LEFT JOIN tbl_city as d ON AND d.status='Active' LEFT JOIN tbl_readsdetail as re ON re.pa_id WHERE a.status='A' AND ((a.ad_title like '%t����mbaram%' OR a.ad_description like '%t����mbaram%') OR (c.sub_name like '%t����mbaram%' OR b.cate_name like '%t����mbaram%') OR like '%t����mbaram%') order by a.created_on desc
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'