--== Help with SQL query ==--
Thread Starter
Scooby Regular
Joined: Nov 2001
Posts: 4,788
Likes: 0
I have an ASP page I have written which displays the results from an SQL database from a simple html page query. I need to know how to query the database for any records which 'contain' the query, not 'equal' to the query.
E.g.
Record 1 fruits: "apples, pears, oranges"
If I do a select * from fruits where "query" = 'apples' it wouldn't display record 1 in the results.
Is there any way of displaying record 1 because it contains the word apples within it??
Thanx.
E.g.
Record 1 fruits: "apples, pears, oranges"
If I do a select * from fruits where "query" = 'apples' it wouldn't display record 1 in the results.
Is there any way of displaying record 1 because it contains the word apples within it??
Thanx.
Thread
Thread Starter
Forum
Replies
Last Post
Mkhan
Non Scooby Related
14
Aug 9, 2001 02:07 AM