• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • 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


john lambert
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.

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

Glad I could help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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