Posted by petersprc on 06/21/07 19:42

On Jun 21, 3:00 pm, j...@fastermail.com wrote:
> I need some assistance on how to create a select statement using PEAR
> DB or MySQL with the LIKE function.
> That is I am looking of how I can get statement like this work.
> SELECT * FROM customer WHERE name LIKE '%?'

require_once('MDB2.php');

$mdb2 = MDB2::singleton('mysql://user:password@host/db');
$mdb2->loadModule('Extended');

$rows = $mdb2->extended->getAll(
'select * from customer where name like ?',
null, array('%bob%'));

[Back to original message]