Data matching & appending in Excel or SQL

IN PROGRESS
Bids
6
Avg Bid (AUD)
$22
Project Budget (AUD)
$10 - $30

Project Description:
Small project- looking for bids of $10

Need someone to setup queries so a master list column is referred to and based on provided keywords (most with wild card front and back) append associated flaggings.

Notes:
• % represents wild card. For example, sm%th finds "smith" and "smyth". Also %east finds "Northeast" and "Southeast"
• where % does not exist, there is no wild card
• space sensitive (Very Important)
• not case sensitive
• where there is more than one 'Job Folders' or 'Job Level' separate with ; in the same cell.
• conditions include where a keyword exists or where a keyword does not exist -append a code.

See attached for production file. Let me know if you have any questions.

Skills required:
Database Administration, Excel, MySQL, SQL
Additional Files: Back Testing.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 15
in 1 days
$ 25
in 1 days
$ 10
in 1 days
$ 25
in 3 days
$ 30
in 3 days
$ 24
in 1 days