Help for this page

Select Code to Download


  1. or download this
    create table nodes (
        node_id integer not null primary key,
    ...
    insert into nodes (node_id, message,location) values (4,'Re: Re: Hello
    + (1)','AA');
    insert into nodes (node_id, message,location) values (5,'Re: Re: Hello
    + (2)','AB');
    insert into nodes (node_id, message,location) values (6,'Re: Re: Hello
    +!','BA');
    
  2. or download this
    select node_id, location from nodes
    where location like 'A%'
    order by location asc