table的字段details里都是一些这样的内容property = 'NEWIR' PK.account = '10010000027' LastUpdated 'Jul 12 2006  2:05PM' => 'Oct 22 2012  5:30PM' ETX  STX TABLE.guest = CHG PK.property = 'NEWIR' PK.account = '10010000027' status 'R' => 'C' caller 'SELF' => 'AA' cxl_clk 'NULL' => 'HIS' cxl_date 'NULL' => 'Jul 10 2006  5:30PM' cxl_acct 'NULL' => '10010000001' cxl_code 'NULL' => 'AVAIL' ETX  STX TABLE.multirate = CHG PK.property = 'NEWIR' PK.account = '10010000027' PK.rate_date = 'Jul 10 2006 12:00AM' inventory 1 => 0 ETX  STX TABLE.multirate = CHG PK.property = 'NEWIR' PK.account = '10010000027' PK.rate_date = 'Jul 10 2006 12:00AM' LastUpdated 'Jul 12 2006  2:05PM' => 'Oct 22 2012  5:30PM' ETX  STX TABLE.guest_names = CHG PK.property = 'NEWIR' PK.account = '10010000027' PK.name = 'TAM, MR ALAN' ETX  STX TABLE.guest = CHG PK.property = 'NEWIR' PK.account = '10010000027' ETX  STX TABLE.guest = CHG PK.property = 'NEWIR' PK.account = '10010000027' comments '' => 'NO AVAILABLE' arr_note '' => '' dep_note '' => '' ETX

现在我想把其中的status 'R' => 'C'为条件查询出来，使用Like不能查询出来了
select * from activity_log where details like '%status 'R' => 'C'%'
这个语句无法使用，请问怎样才能查询出想要的结果，谢谢帮忙！

我想问一下：你是如何做到在table表中details字段里插入带单引号的记录？？

数据库里面自己生成的LOG

hao

把条件分开，如：
select * from activity_log where details like '%status %' and details like '%R%'and  details like '%=>' and  details like '%C%'