Äõ¸®¿¡¼ ¿¡·¯°¡ ³µ½À´Ï´Ù. |
Äõ¸®¹® |
select b.*, a.* from R_life_mamul a, R_life_expiry b where a.`no`=b.`pno` and a.`code`='sell' and a.`open`='yes' 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 '%���%' ) and (b.`line`>=curdate() or b.`preferential`>=curdate() or b.`premium`>=curdate() or b.`premium`='1111-11-11' or b.`preferential`='1111-11-11' or b.line='1111-11-11') limit 5 |
|
¿¡·¯¸Þ¼¼Áö |
ERROR CODE 1267 : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation \'like\' |
|
ÆäÀÌÁö |
/display/search_all.html |
|
| |