Äõ¸®¿¡¼ ¿¡·¯°¡ ³µ½À´Ï´Ù. |
Äõ¸®¹® |
select count(*) from `R_life_mamul` as a, `R_life_expiry` as b where a.no=b.pno and a.`code`='job' and ( a.`build_name` like '%��ϵ�%' or a.`form_txt` like '%��ϵ�%' or a.`pno_text` like '%��ϵ�%' or a.`mutual` like '%��ϵ�%' or a.`tel` like '%��ϵ�%' or a.`goods` like '%��ϵ�%' or a.`job` like '%��ϵ�%' or a.`address` like '%��ϵ�%' or a.`add_content` like '%��ϵ�%' or a.`content` like '%��ϵ�%' ) and a.form_txt='business' and (b.`premium`>='2024-04-20' or b.`premium`='1111-11-11') and a.open='yes' |
|
¿¡·¯¸Þ¼¼Áö |
ERROR CODE 1267 : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation \'like\' |
|
ÆäÀÌÁö |
/display/list.html |
|
| |