Đang Thực Hiện

Rework SQL query to catch wildcard email from the table

Hello,

Currenly I have a table "addresses" where there are field "id" and "email"

email field may have multiple records such as: abc@[login to view URL];bcd@[login to view URL];eee@[login to view URL]

with email addresses separated by semicomma, and SQL query which is extracting ID by email variable from addresses:

select id from addresses where FIND_IN_SET( " $email ", REPLACE( `email`, ";", "," ) ) > 0;

I need to rework this SQL request to be able to catch wild card emails as well.

For example if filed email has next record:

abc@[login to view URL];bcd@[login to view URL];eee@[login to view URL];*@[login to view URL]

your query should return id from the table when whilecard email variable is matching to domain, for example: test@@[login to view URL]

Kĩ năng: SQL, MySQL, Microsoft SQL Server, PHP

Xem nhiều hơn: sql query find child parent items table, sql query parents table, sql query filter table, sql query check child table, sql query tree structure table, tree table sql query, display table sql query result joomla, filtering jsp table sql query, recursive sql query menu table, sql query data table tree, sql query insert data child table, sql query automatically email, email sql query results, import csv table sybase sql query, T-SQL Try Catch Error Trapping and Error Logging to a Table for about 20 Insert Queries , sql query update email address, export sql table to csv using sql query, convert a sql query result table to an html table for email, send sql query results to email

Về Bên Thuê:
( 16 nhận xét ) Wantirna South, Australia

ID dự án: #24073414

Được trao cho:

leonhahn

fast i can complete it. I am skilled in mysql database for longtime. I have read your project and i [login to view URL] start work

$20 AUD trong 1 ngày
(0 Đánh Giá)
0.0

4 freelancer đang chào giá trung bình $20 cho công việc này

Sohail748

Hello Dear...! Alert: I will give you 20% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that your Looking a developer which hav Thêm

$10 AUD trong 1 ngày
(4 Nhận xét)
2.4
Fespinosa17

Hi. It is 10min job for me. May I expect to be hired from you? Please hire me. Thanks, Fabian.

$30 AUD trong 1 ngày
(1 Nhận xét)
1.8
satarupghoshal

No time waster here. A full stack freelance developer is ready to start the work as soon as you approve me the same and submit the deliverable in agreed timeline with quality and optimized coding pattern. I specialize Thêm

$19 AUD trong 1 ngày
(0 Nhận xét)
0.0