How to replace specific strings between two strings in php

Question

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

malutki5200 · Accepted Answer · 2016-11-24 10:53:13Z

3

Use the following regexp:

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

The whole solution would require something like that:

preg_match_all($regexp, $string, $matches);

answered Nov 24, 2016 at 10:53

malutki5200

1,1128 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to replace specific strings between two strings in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related