michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: SELECT * FROM animals WHERE species_id = ? ORDER BY name
michael@0: 2
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: SELECT * FROM animals WHERE species_id = ? ORDER BY name
michael@0: 2
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: SELECT * FROM animals WHERE species_id = :spec AND name like ? ORDER BY name
michael@0: 5
michael@0: L%
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: SELECT * FROM animals WHERE species_id = ?3 AND name like ?1 ORDER BY name
michael@0: 5
michael@0: L%
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: SELECT * FROM animals WHERE species_id = ?3 AND name like :pattern ORDER BY name
michael@0: L%
michael@0: 5
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: SELECT * FROM animals WHERE species_id = ? ORDER BY name
michael@0: 2qsdqsd
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0:
michael@0: