[BioPython] Help formatting mysqld queries
Andrew Nunberg
anunberg at oriongenomics.com
Mon Dec 22 12:21:24 EST 2003
I wish to execute the following query
d.execute('select start,end from repeat_features where trace_id=%s and
repeat like "%TERT001%"',trace_id)
I can get around this by replacing the %TERT001% with more formatting
Eg
Like=r¹%TERT001%¹
...and repeat like ³%s²,[trace_id,like]
Is there a way to escape the % formatting character? I tried \ and that
didn¹t work
Andy
--
Andrew Nunberg
Bioinformagician
Orion Genomics
(314)-615-6989
www.oriongenomics.com
More information about the BioPython
mailing list