[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