• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

regex code how to filter this sql email combo

insert into `yahoo`.`users`(`id`,`email`,`password`) values (1,'emilywhittaker25@yahoo.com','emily');

Open in new window


output:

emilywhittaker25@yahoo.com','emily
0
john lambert
Asked:
john lambert
  • 2
1 Solution
 
Dan CraciunIT ConsultantCommented:
You should simply make the inserts in a temp table and then select the email and password.

If you insist on regex:
insert into `yahoo`\.`users`\(`id`,`email`,`password`\) values \([0-9]+,'([^)]+)'

The result will be in group 1.

HTH,
Dan
1
 
john lambertAuthor Commented:
i test it and works perfect thank you...
0
 
Dan CraciunIT ConsultantCommented:
You're welcome!

Glad I could help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now