...

View Full Version : Select 'Like' ODBC / MS Access / PHP



eksob
03-19-2007, 06:49 PM
I am trying to do a select 'LIKE' statement but I am not returning any results, here is what I am trying:


$get = "SELECT item FROM table WHERE item LIKE 'D123-78*'";
$ex = odbc_exec($conn, $get);

But in access there are several items:

D123-78-567
D123-78-432
D123-78-113

Inigoesdr
03-19-2007, 11:23 PM
What is the problem? Unless I'm misunderstanding you, that's how LIKE is supposed to work.

marek_mar
03-20-2007, 12:31 AM
You might want to try % instead of *.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum