SQLite Forum

Using a numbered parameter (such as ?4) more than once in an SQL statement
Can a numbered parameter be used more than once in an SQL statement, such as:

select * from mytable where id1=?1 and id2=?1 and ...

I had a feeling I'd read somewhere that this works, but I can't find it now. I'd like to know that it's "works as intended and guaranteed", rather than "happens to work in this version but no promises for future versions".

Thanks for an insight.