Time : 11:26:12 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(a.no_kontrol) <10 AND b.id_dpjp >1000 AND a.id_no_skdp>407289 ORDER BY ' at line 3 Raw SQL : SELECT a.tanggal,a.`id_no_skdp`,a.no_cm,a.no_reg,a.no_kontrol,a.is_booking,b.id_register,b.id_catatan_medik,b.no_sep,b.id_dpjp,b.poli_tujuan, a.tgl_batas FROM mr_no_skdp a LEFT JOIN sep b ON (a.no_reg=b.id_register) WHERE a.id_surat='1' LENGTH(a.no_kontrol) <10 AND b.id_dpjp >1000 AND a.id_no_skdp>407289 ORDER BY a.id_no_skdp LIMIT 1