Đã Đóng

MYSQL - Replace Multiple Values In Select Statement

I have a script to search my MYSQL database, it uses a lot of REPLACE functions to eliminate the commas, apostrophes and periods when it searches the MYSQL database. The problem is that because it uses so many REPLACE functions I believe it's using up too much of MYSQLs resources and slowing down the server. So I'm looking for an alternative method to do this or some kind of way of breaking down this function to use less resources. Here's what the code looks like:

SELECT * FROM database WHERE

( table LIKE '$search_query_all%'

OR REPLACE(table, ',' ,'') LIKE '$search_query_all %'

OR REPLACE(table, ',' ,'') LIKE '% $search_query_all'

OR REPLACE(table, ',' ,'') LIKE '% $search_query_all %'

OR REPLACE(table, ',' ,'') LIKE '%$search_query_all.%'

OR REPLACE(table, ',' ,'') LIKE '%$search_query_all,%'

OR REPLACE(table, ',' ,'') LIKE '%$search_query_all!%'

OR REPLACE(table, ',' ,'') LIKE '%$search_query_all?%'

OR REPLACE(table, ',' ,'') LIKE '%$search_query_all:%'

OR REPLACE(table, ',' ,'') LIKE '%$search_query_all;%'

OR REPLACE(table, '.' ,'') LIKE '$search_query_all %'

OR REPLACE(table, '.' ,'') LIKE '% $search_query_all'

OR REPLACE(table, '.' ,'') LIKE '% $search_query_all %'

OR REPLACE(table, '.' ,'') LIKE '%$search_query_all.%'

OR REPLACE(table, '.' ,'') LIKE '%$search_query_all,%'

OR REPLACE(table, '.' ,'') LIKE '%$search_query_all!%'

OR REPLACE(table, '.' ,'') LIKE '%$search_query_all?%'

OR REPLACE(table, '.' ,'') LIKE '%$search_query_all:%'

OR REPLACE(table, '.' ,'') LIKE '%$search_query_all;%'

OR REPLACE(table, ''' ,'') LIKE '$search_query_all %'

OR REPLACE(table, ''' ,'') LIKE '% $search_query_all'

OR REPLACE(table, ''' ,'') LIKE '% $search_query_all %'

OR REPLACE(table, ''' ,'') LIKE '%$search_query_all.%'

OR REPLACE(table, ''' ,'') LIKE '%$search_query_all,%'

OR REPLACE(table, ''' ,'') LIKE '%$search_query_all!%'

OR REPLACE(table, ''' ,'') LIKE '%$search_query_all?%'

OR REPLACE(table, ''' ,'') LIKE '%$search_query_all:%'

OR REPLACE(table, ''' ,'') LIKE '%$search_query_all;%'

)

Tell me how you plan to make your method work when you bid, do not bid without leaving a comment letting me know you fully understand the task and how to complete it.

Kỹ năng: MySQL, PHP, Thiết lập Bản thảo, SQL

Xem thêm: mysql replace multiple values, mysql select replace multiple, mysql multiple replace, mysql replace multiple, mysql replace, multiple select replace mysql, mysql replace values, replace values mysql, multiple replace mysql, work alternative, statement problem, make statement problem, make problem statement, problem statement, mysql select replace, replace values select, mysql replace select, mysql replace values select, select, replace, mysql code search, mysql select statement, mysql search table, comment mysql, php search replace

Về Bên Thuê:
( 201 nhận xét ) N/A, United States

Mã Dự Án: #1047106

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

jqMike

Please see PM.

$60 USD trong 0 ngày
(58 Đánh Giá)
6.7
bsoist

Please see PMB .

$50 USD trong 1 ngày
(34 Đánh Giá)
6.4
AStonetech

I could do this quickly, lets start right now.

$52 USD trong 1 ngày
(115 Đánh Giá)
6.4
developershut

Hi, please check PM for details

$50 USD trong 1 ngày
(54 Đánh Giá)
6.0
emicsoft211

Hello, Please check pmb.Thank you

$70 USD trong 3 ngày
(15 Đánh Giá)
5.2
hexnorify

Hi Please check my reviews if you're interested. Regards

$50 USD trong 1 ngày
(6 Đánh Giá)
4.4
Naaraxi

See PM for details.

$30 USD trong 1 ngày
(12 Đánh Giá)
4.1
cicika

Hello! Please check private msgs. Thanks!

$60 USD trong 2 ngày
(4 Đánh Giá)
3.9
amsak

pls see pm

$50 USD trong 7 ngày
(7 Đánh Giá)
3.6
Navig8

Please see PMB

$150 USD trong 1 ngày
(5 Đánh Giá)
2.8
valdaszigas

Hi. Please check PMB.

$30 USD trong 1 ngày
(1 Đánh Giá)
2.8
Frankie4Fingers

I'm ready to start right now.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
smbakhtiar

I am ready.

$100 USD trong 1 ngày
(0 Đánh Giá)
0.0
neocanable

Hi,this definitely is not big deal. I can take up your project. And ,i have portfolio that i can show you. please contact me.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
Solithus

i can do it now..

$30 USD trong 0 ngày
(0 Đánh Giá)
0.0