Looking for MySQL expert to create Trigger

Looking for MySQL expert to create Trigger, which will execute after each select query IF the exactly column names (as a pattern) EXIST in the select query.


We have a table with columns: id, country, state, city, address

The trigger MUST be executed only IF the select query contains "id" and "state" and not other column names, here is a short example:

Trigger executed:

SELECT id, state FROM our_table;

SELECT id, state FROM our_table WHERE country LIKE 'some_country' AND address LIKE 'any_address';

Trigger NOT executed:

SELECT id, country, city, address FROM our_table WHERE country LIKE 'some_country';

SELECT id, state, city FROM our_table WHERE city LIKE 'some_city';

SELECT state FROM our_table WHERE id < 5;

Quick question for MAX $10!!!!

Please bid if you can provide the query shortly and you are agreed with the $10 rewards!!!

Thank you

Skills: MySQL, PHP, Software Architecture, Javascript, SQL

See more: mysql netezza create table, create breezingforms thank note mail, looking quickbooks expert, create trigger in mysql workbench, mysql trigger on update specific column, create trigger mysql, create mysql trigger in java, mysql trigger before insert, mysql alter trigger, drop trigger mysql, mysql trigger after insert or update, looking freelance copywriter create product descriptions, php mysql expert, looking nagios expert, php mysql expert wanted, php mysql workorder create, thank quick turn around, create clickbank thank page, mysql expert freelancer, mysql php create appointment

About the Employer:
( 9 reviews ) Melnichnoe, Ukraine

Project ID: #23553832

16 freelancers are bidding on average $84 for this job


Hello. I am really interested in your project. I have enough experience on python, C/C++, C#, java,My SQL programming. I am 100% sure i can satisfy your requirements perfectly. User-Friendly Interface And Clear Algorit More

$200 USD in 7 days
(13 Reviews)

Hi there, There is no way in MySQL to create a trigger on a select query. But I can do what you are trying to do using the general query log in MySQL. So by enabling this all the queries will be logged and then we can More

$250 USD in 7 days
(44 Reviews)

I am a full-stack developer with a career in the IT industry of over 4 years. I have rich experiences with many people and they always get the best result. It's a piece of cake for me! You'll not waste your GOLD TIME. More

$55 USD in 2 days
(11 Reviews)

I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development, AI, Mobile Development and various exepertise in Graph More

$90 USD in 7 days
(56 Reviews)

Hi i read your requirement. you want create trigger in select query. I can do [login to view URL] chat me for details. Thanks Jaffer A.

$40 USD in 2 days
(15 Reviews)

Hello. I am a Web developer with experience in Mysql. I can create trigger for you in short time. Hit me up.

$55 USD in 2 days
(5 Reviews)

Sir, I am a MySQL expert databases and I can write the queries and the trigger you need. Please initiate the chat for detail discussion of the project. I look forward to working with you. Thanks for reading. Best Regar More

$30 USD in 3 days
(6 Reviews)

I can help you to complete your task within 2 days. as i have an experience of 10+ overall experience and 4+ years in MySQL Database. Also i am expert in writing triggers. Initiate the chat and share the details.

$111 USD in 2 days
(1 Review)

Hi. You can't create trigger on SELECT command (only INSERT, UPDATE or DELETE). This can be done using you code (ORM) or some middleware between database and data consumer (client, API, ..). Can you describe your task More

$30 USD in 1 day
(1 Review)

I agree $10 reward. I have read your requirement and I can do this task please let me know if this is still available so we can discuss more

$30 USD in 7 days
(0 Reviews)

Hello. I am really interested in your project.I am sure i can satisfy your requirements perfectly. User-Friendly Interface And Clear Algorithm Will Encourage Your Project. I want a long term relationship with you.

$30 USD in 6 days
(0 Reviews)

Hello, I'm Jonathan. I have had over 4 years of experience building triggers and stored procedures for normalised and denormalised databases. From your example, I will first check if the new id and state are not null More

$40 USD in 2 days
(0 Reviews)

Database developer with 9 year experience Relevant Skills and Experience Database developer with 9 years exp

$155 USD in 3 days
(0 Reviews)

Hi, Please connect with me for more details, I am having various project experience. I have done such task earlier also. Thanks, Kamlesh Gahlot

$50 USD in 7 days
(1 Review)

Hi I have 5 years experience as a DBA and Database Developer. I have experience in big IT companies which have more then 200 IT professionals

$111 USD in 3 days
(0 Reviews)

I'm always interested to work on SQL projects. I have read you requirements and I can can do it. Please reach me if you ok.

$65 USD in 7 days
(0 Reviews)