Need Keyword search script optimized

Need to improve the relevant keyword php script.

The current script takes keywords that have been generated for each campaign in our database. The script [url removed, login to view] takes each one of these keywords one by one and searches qa_keywords using special conditions to find matches in database of over 540,000 keywords and growing.

It then stores these keyword on campaign table under relevant keywords so advertisers can bid on them.

The problem is it collecting relevant keywords as expected.

Here are the conditions?

The conditions of what results we store are determine in admin. Example lets say we are searching qa_keywords for “high school”. In admin, we set for 2 word keywords, return results no more than 3 keywords.

So results can be if found,

· central high school

· High school bands

· High school

The Problem is to optimize the search function of how it search for keywords. It needs to produce results as intended.

I think the script searches in database using the like function in stead of exact. I was told that the exact function takes longer. I think this is why some of the results I receive are not relevant.

Skills: Javascript, MySQL, PHP

See more: searching problem, search here, php script school, php school script, keyword find, word script, keyword search, optimize improve, word find function, function search, php keyword, keyword results, javascript optimize, school search, php script searches, php keyword script, php search database table, javascript need, improve current database, school admin, search database script, javascript word search, php script search database, script search return, function search php

About the Employer:
( 110 reviews ) hayneville, United States

Project ID: #1092654

8 freelancers are bidding on average $116 for this job


We can fix this. Please check PM. Thanks

$150 USD in 2 days
(150 Reviews)

Hello PHP/MySQL expert here, Already done similar project. Please view PMB, Thanks Harish.

$125 USD in 2 days
(77 Reviews)

Dear Sir/Madam, Please check your inbox. Best Regards, TIA Team.

$250 USD in 3 days
(30 Reviews)

Hello. Please check PMB.

$100 USD in 2 days
(10 Reviews)

hi optimizehosting, please check your PM.

$60 USD in 2 days
(3 Reviews)

Proper way is implementing [url removed, login to view] I can do this for you.

$200 USD in 10 days
(1 Review)

I think i know the solution sir

$110 USD in 2 days
(0 Reviews)

I am ready to start, more details please, thanks.

$80 USD in 4 days
(1 Review)

Dear client, This is Reena from Freelancers group. We are young talented group of web designers and programmers. We have confident that we will provide you quality website in stipulated [url removed, login to view] offers web develo More

$100 USD in 2 days
(0 Reviews)