查询疑问
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'%'
这个语句无法使用,请问怎样才能查询出想要的结果,谢谢帮忙!