Mysql problem with BLOB and INSTR/LIKE

$10-30 USD

Zamknięte

Opublikowano

prawie 8 lat temu

$10-30 USD

Płatne przy odbiorze

Im trying get in an array all data1 that found search1 in the table dbtable1: $q = mysql_query("SELECT * FROM dbtable1 WHERE INSTR(data1, 'search1')") ; I also tried with: $q = mysql_query("SELECT * FROM dbtable1 WHERE data1 LIKE '%search1%'"); but i dont get results and im sure that some data1 in my db have the string that im searching in search1. maybe i have an error int he syntax. thanks.

MySQL

PHP

Identyfikator projektu: 10957909

Informację o projekcie

20 ofert

Zdalny projekt

Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

20 freelancerzy składają oferty o średniej wysokości $23 USD dla tej pracy

@moonwebtech

Hi, We are a skilled development team and we are working in web development for the last four years we can complete your task in efficient time and cost please fell free to contact us Thanks moonwebtech

$30 USD w 1 dzień

5,0

(217 opinii)

7,3

@bhagwansahane89

come on chat to solve now

$10 USD w 0 dzień

4,7

(35 opinii)

5,2

@vinaysinghh

A proposal has not yet been provided

$15 USD w 1 dzień

4,9

(46 opinii)

5,2

@sanjayahlawat1

Sir, I can do this project .Tell me more about your project. My goal is to provide best service for my clients in minimum possible amount. I will accept projects only when i'm 100% sure. Thanks! :)

$15 USD w 0 dzień

4,2

(28 opinii)

5,5

@WebMediaPak

Dear Employer, I am ready to work on your required task and can also give 100% satisfaction. Looking forward to an opportunity to work with you. Warm Regards: WebMediaPak

$25 USD w 1 dzień

5,0

(29 opinii)

4,4

@jasleen11

Greetings Ready to fix the issue with blog and INSTR/LIKE . Please share the link of the site and let em know when can we discuss I am expert in php and insure you to provide the work as you are looking for . Waiting for your Response. Kind Regards

$30 USD w 1 dzień

4,8

(18 opinii)

4,3

@shennz

Hi, I'm a developer having experience in MySQL. I can provide you with high standard work. I'm ready to start work right now. Please PM me for more details. Thank You

$20 USD w 0 dzień

4,9

(22 opinii)

4,5

@joomlaexpert989

Hello, I m having expertise in MySQL.I would like to write this query for you. Looking forward for your reply. Thanks

$30 USD w 1 dzień

4,8

(15 opinii)

4,3

@hssoftwares

With my 7 years of experience in Web development including PHP, Mysql, HTML, JS, AJAX, JQUERY, CSS, Drupal, Joomla, Magento, Wordpress, etc, I can give you the quality output with sincere effort. I am looking forward to work with you. Thank you.

$10 USD w 1 dzień

4,9

(6 opinii)

3,6

@anujayk

A proposal has not yet been provided

$35 USD w 1 dzień

4,7

(8 opinii)

2,8

@rakeshrawat88

A proposal has not yet been provided

$25 USD w 1 dzień

0,0

(0 opinii)

0,0

@trups06

A proposal has not yet been provided

$27 USD w 1 dzień

0,0

(0 opinii)

0,0

@djafferian

I have 7 years of experience troubleshooting MySQL problems like this one. I will send you a script to include just before your call to mysql_query to collect information about the database and the connection. If the data collected is insufficient to pinpoint the cause of the problem, further data collection may be needed. I will explain why INSTR and LIKE do not produce the expected result and what modifications to the SELECT statement are possible to obtain the expected result.

$30 USD w 1 dzień