import de.bezier.data.sql.*;

MySQL msql;

void setup() {
  String user     = "bob";
  String pass     = "password";
  String database = "test";
  //String table    = "htmlparse";
  String table    = "mytable";

  msql = new MySQL( this, "localhost", database, user, pass );
  if ( msql.connect() ) {
    msql.execute( "CREATE TABLE IF NOT EXISTS " + table + " ("+
      "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"+
      "word VARCHAR( 255 )"+")");
  }
  else {
    println("connection failed!");
  }
  msql.query( "SELECT * FROM " + table );
  while (msql.next())
  {
    //if (msql.getInt("id") == 1){
    String s = msql.getString("word");
    println(s);
//    println(s + "-- row #" + msql.getInt("id"));
    //}
  }
  String searchWord = "ipsum";
  msql.query( "SELECT * FROM " + table + " WHERE word LIKE \"%" + searchWord + "%\"" );
  while (msql.next())
  {
    String s = msql.getString("word");
    int n = msql.getInt("id");
    println(s + " -- row #" + n);
  }
}