[sqlalchemy] Re: Performing a search

2006-11-06 Thread Dennis
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),

[sqlalchemy] Re: Performing a search

2006-11-06 Thread Martin Kaffanke
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