PHP Classes

->select()

Recommend this page to a friend!

      Easy MySQL Query  >  All threads  >  ->select()  >  (Un) Subscribe thread alerts  
Subject:->select()
Summary:where clause in select
Messages:2
Author:rudie dirkx
Date:2010-09-25 22:23:24
Update:2010-10-26 16:54:01
 

  1. ->select()   Reply   Report abuse  
Picture of rudie dirkx rudie dirkx - 2010-09-25 22:23:24
What happens if I wanna do:

$where = array(
'nome LIKE ? ||' => $mysql->escape('a%'),
'nome LIKE ? ||' => $mysql->escape('b%'),
'nome LIKE ? ||' => $mysql->escape('c%'),
'nome LIKE ? ' => $mysql->escape('d%')
);
$mysql->select('contato', 'nome,endereco', $where);

to achieve:

SELECT ... WHERE nome LIKE 'a%' || nome LIKE 'b%' || nome LIKE 'c%' || nome LIKE 'd%'

It doesn't seem possible; is it?

  2. Re: ->select()   Reply   Report abuse  
Picture of Enio Borges Ribeiro Enio Borges Ribeiro - 2010-10-26 16:54:01 - In reply to message 1 from rudie dirkx
Hi Rudie!
I update the class and add this option!

Thanks!