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:
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!!!
16 freelancere byder i gennemsnit $84 på dette job
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.
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.