1 Replies - 1778 Views - Last Post: 21 May 2006 - 08:29 PM Rate Topic: -----

#1 thorny  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 17-May 06

Query based off of text input

Posted 21 May 2006 - 07:27 PM

Hi, whats the code i can use?? say I have a input box in a form and when a button is pushed it runs a a query and that query takes what the user has inputed and search the databse for the details matching the input. Now I have it all set up but the query runs using input but it must be the exact word and spelling to find the details. What code can i use in SQL in the query to make the query find anything similar. eg input = Jo, query finds details matching= jo, joanna, john etc HELP!!!

Is This A Good Question/Topic? 0
  • +

Replies To: Query based off of text input

#2 frog  Icon User is offline

  • unleashed
  • member icon

Reputation: 2
  • View blog
  • Posts: 683
  • Joined: 26-March 06

Re: Query based off of text input

Posted 21 May 2006 - 08:29 PM

well i just know a liitle bit of sql but i suupose this would work
SELECT *
FROM table
WHERE name LIKE "jo%";


Was This Post Helpful? 0
  • +
  • -

Page 1 of 1