Search results

Thanks again Ken If I don't get any more relpies I will repost.

I'm not the database expert just trying to speed his job up as he still has quite a bit to do. The answer to your first question is yes we are using Access and querying directly from the asp code. The search searches four feilds all text if I remember correctly, title, description, keywords...

Thanks for the help so far Ken I have sent a private message so you can see the site I am trying to sort out and the problem I have If you search for "car" in the UK you get 17703 results including car, cars, carpets, Montecarlow, heathcare etc...

The database has 150,000+ records and the search searches 4 feilds so it would not be ideal but possible yes.

I tried it and the results are much better, however, it still brings up results where the word begins or ends with the search word. Is there something I can add before "mywordone " and after " mywordone" to stop this partial word match?

Looks like it should work I will try it, thanks

I thought of that but would it not miss the first or last words out?

Please forgive my ignorance but I am trying to do a search and am presently using 'like' which works but returns a lot of irrelevant results i.e partial words that contain the search term. Is there an easy way to search only for whole words within records that match the search word/s

People are very helpful on this forum thanks NJudson

Works great thanks one last question I tried adding other fields and it didn't work message says: you tried to execute a query that does not include the specific expression 'id' as part of an aggregate function. SELECT adverts.id, adverts.title, adverts.name, adverts.url, Count(adverts.url) AS...

NJudson I tried that and got an error message, did I do something wrong? Syntax error (missing operator) in query expression 'Count[adverts].[title]'.

I have a database of 100,000+ entries and have some records that are duplicated. how can I write a query to pull out all records that have two or more identical entries, and if possible can this be sorted by the number of duplicates of a particular entry SELECT adverts.title FROM adverts WHERE ???

Thanks Pbaldy

Entering data I have created the following sql query to search for records that contain 'thistext' anywhere in the record and to display that record. SELECT adverts.title FROM adverts WHERE (((adverts.title) Like "*thistext*")); The query works fine, however, I have to perform this a number...

Thanks Bat17 and SJ McAbney for the fast response I have changed the 'name' field and it works like a dream

Sorry if it is a dumb question but how do I add it to this sql query SELECT adverts.title, adverts.name FROM adverts; title is the field I need sorting by length

How do I order by length? Hi I have a database of over 100,000 records with 20+ feilds One of the feilds is a text feild (250) I need to sort this feild so that it displays the records by length, so I can reduce the longest entries to say 80 characters. The editing needs to be done by hand...