Searching in a DataBase

• • Reply

  19 years ago

  by bigd

  bigd

  Invermere, United States

  Joined 19 years ago

  I need to find a way that I can Search in a Database Program, I have the entering data part, I just need some help to search my Database, I need it to also display multipul enteries, ex 4 Jones,

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  Try using an SQL statement, such as
  

  
  SELECT id,title FROM mytable WHERE description like '%plants%'

  Report abuse
• • Reply

  18 years ago

  by tlkelley

  Super Tal

  Montgomery, United States

  Joined 19 years ago

  Try looking at the built in search wizard.  Click the wizard button, then add the button, select the Search option.  This button will then search your database based on the field you are on... I believe there are other options, too..
  

  
  It basically does a SELECT like the one James mentioned.
  

  
  Good luck.
  

  
  

  Report abuse