On Nov 6, 4:29 am, Alexandre CONRAD [EMAIL PROTECTED] wrote:
Hello,
what would be the best way to perform a search against columns of a
table ? I have the following code that works fine:
pattern = %bla%
client_list = self.query.select(or_(model.Client.c.name.like(pattern),
Am Montag, den 06.11.2006, 16:15 + schrieb Dennis:
SELECT clients.name AS clients_name, clients.contact AS clients_contact,
clients.email AS clients_email, clients.id_client AS clients_id_client
FROM clients
WHERE clients.name LIKE %s OR clients.contact LIKE %s OR clients.email
LIKE