Search results

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

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 ???

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...

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...