dongshao9106
2016-11-24 10:50
采纳率: 100%
浏览 211
已采纳

如何在php中替换两个字符串之间的特定字符串

I would like to generate sql from this template :

select * from event where 
status_id = 'TOREPLACE_1' 
or status_id = 'TOREPLACE_2'
....

to have this result :

select * from event where 
status_id = (select id from name = 'TOREPLACE_1' limit 1)
or status_id = (select id from name = 'TOREPLACE_2' limit 1)
.....

the question is how to select the expression between '' after every status_id =

Thanks

图片转代码服务由CSDN问答提供 功能建议

我想从这个模板生成sql:

   select * from event where 
status_id ='TOREPLACE_1'
or status_id ='TOREPLACE_2'
 .... 
   
 
 

得到此结果:

  select * from event where 
status_id =(select name from name ='TOREPLACE_1'limit 1)
or status_id =(select name from name ='TOREPLACE_2'limit 1)
 ..  ... 
   
 
 

问题是如何在每个 status_id = 之后选择''之间的表达式 / p>

谢谢

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douhuan6305 2016-11-24 10:53
    已采纳

    Use the following regexp:

    /status_id\s*=\s*\'([^\']+)\'/
    

    The whole solution would require something like that:

    preg_match_all($regexp, $string, $matches); 
    
    打赏 评论

相关推荐 更多相似问题