Journal of Photosciences

select wr_id, wr_subject from g4_write_journal where wr_is_comment = 0 and wr_num = '-104' and wr_reply < '' and ((INSTR(LOWER(wr_subject), LOWER('mycosporine-like')) or INSTR(LOWER(wr_1), LOWER('mycosporine-like')) or INSTR(LOWER(wr_subject), LOWER('mycosporine-like')) or INSTR(LOWER(wr_content), LOWER('mycosporine-like'))) (INSTR(LOWER(wr_subject), LOWER('amino')) or INSTR(LOWER(wr_1), LOWER('amino')) or INSTR(LOWER(wr_subject), LOWER('amino')) or INSTR(LOWER(wr_content), LOWER('amino'))) (INSTR(LOWER(wr_subject), LOWER('acid')) or INSTR(LOWER(wr_1), LOWER('acid')) or INSTR(LOWER(wr_subject), LOWER('acid')) or INSTR(LOWER(wr_content), LOWER('acid'))) ) order by wr_num desc, wr_reply desc limit 1

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 '(INSTR(LOWER(wr_subject), LOWER('amino')) or INSTR(LOWER(wr_1),

error file : /2010/bbs/board.php