query not executing

[boogyman]

I created a customized query to search through my database for a given range of numbers, however when I do it the general way it cannot execute

$query = mysqli_query($conn, "SELECT doc_id,ref_number,title,description FROM docs WHERE ref_number=DD%"); 

-or-

$query = mysqli_query($conn, "SELECT doc_id,ref_number,title,description FROM docs WHERE ref_number LIKE DD%"); 

however if I change the query to search for 1 document by the ID, it will execute correctly.

$query = mysqli_query($conn, "SELECT doc_id,ref_number,title,description FROM docs WHERE doc_id=680"); 

is this a possible INDEXing problem?

Note: doc_id is the primary key of the table, and ref_number indexed :| or so I thought

[mbrodin]

Hi Boogyman!

When you seach without "LIKE" you cannot use %-sign, and you forgoted to add ' between LIKE DD% Set it to LIKE 'DD%'. See if this get the results as you want it!

$query = mysqli_query($conn, "SELECT doc_id,ref_number,title,description FROM docs WHERE ref_number LIKE 'DD%'"); 

$query = mysqli_query($conn, "SELECT doc_id,ref_number,title,description FROM docs WHERE ref_number=DD"); 

Best regards,
mbrodin

[boogyman]

you forgoted to add ' between LIKE DD% Set it to LIKE 'DD%'. See if this get the results as you want it!

ahh, the joys of minute character flaws Thanks Mate, that did do the trick

[mbrodin]

ahh, the joys of minute character flaws Thanks Mate, that did do the trick

Great! Always nice to help!

Best regards,
mbrodin