Searching an SQL Database
Posted on 2004-09-23
I would like to include a search facility to one of my webpages which gives the user the chance to search on words of their choice. The search should query one particular field within a table to see if there is a match for their chosen words.
For example I have a table which holds information about a particular new article. The Fields are ref (reference number), newsheadline (News Headline), ndate (Date of Article) and newsarticle (News Article).
I would like the users words to search on the newsarticle (News Article) field and return any records where their chosen words were found in that field.
Any help would be very much appreciated.