fork(1) download 
  1. my_string = "SELECT * FROM users WHERE first_name = 'first name value'"
  2. my_string2 = "SELECT * FROM users WHERE first_name = 'first\"s name value'"
  3. my_string3 = "SELECT * FROM users WHERE first_name = 'first\\'s name value'"
  4.  
  5. rx = /first_name = (?:'(?<val>[^'\\]*(?:\\.[^'\\]*)*)'|"(?<val>[^"\\]*(?:\\.[^"\\]*)*"))/i
  6.  
  7. puts rx.match my_string
  8. puts rx.match my_string2
  9. puts rx.match my_string3
Success #stdin #stdout 0.05s 9744KB
comments (?)
stdin 
Standard input is empty
stdout 
first_name = 'first name value'
first_name = 'first"s name value'
first_name = 'first\'s name value'
https://ideone.com/5ad5xu
language:
Ruby (ruby 2.5.5)
created:
8 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!