[sqlalchemy] Re: problem with like

2009-10-14 Thread Christian Démolis
Thx Kyle and Conor, i finally dit that s = session.query(Contact.IdContact, Contact.Civilite, Contact.Nom, Contact.Prenom, ContactTel.Tel).filter(ContactTel.IdContact==Contact.IdContact).filter(Contact.IdDossier==self.dossierPourChargement.IdDossier) # s =

[sqlalchemy] Re: problem with like

2009-10-13 Thread Kyle Schaffrick
On Mon, 12 Oct 2009 13:47:19 -0500 Conor conor.edward.da...@gmail.com wrote: Christian Démolis wrote: Hi, The idea of creating another column is good but it will multiplicate the size of my table by 2 for nothing. Is it possible to use MYSQL regular expression search with sql

[sqlalchemy] Re: problem with like

2009-10-12 Thread Christian Démolis
Hi, The idea of creating another column is good but it will multiplicate the size of my table by 2 for nothing. Is it possible to use MYSQL regular expression search with sql alcmehy? If yes, what is the command? 2009/10/10 Andre Stechert stech...@gmail.com This is not really a sqlalchemy

[sqlalchemy] Re: problem with like

2009-10-12 Thread Conor
Christian Démolis wrote: Hi, The idea of creating another column is good but it will multiplicate the size of my table by 2 for nothing. Is it possible to use MYSQL regular expression search with sql alcmehy? If yes, what is the command? MySQL supports RLIKE/REGEXP operators; you can see

[sqlalchemy] Re: problem with like

2009-10-09 Thread Andre Stechert
This is not really a sqlalchemy question, but the quick answer is that you need to convert both your indexed data and your queries to the same normal form. In your example, you appear to be correctly stripping spaces and periods in your query. If you haven't done that in the database, then you