I need to write query that only returns key words from one column

I have a query that returns 4 columns but I only want it to return certain key words from one of them (image attached) Is it possible to return a query with only keywords from the third column ie: Compression , Tubigrip
Kirk saintSoftware Designer(Trainee)Asked:
Who is Participating?
 
Ryan ChongCommented:
do you mean this?

select * from yourTable
where MultilistType like '*Compression*' OR MultilistType like '*Tubigrip*' 

Open in new window

0
 
Dale FyeCommented:
no image attached
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
sorry thought that was attached . here it is .
Query-Multilist.PNG
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Ryan ChongCommented:
do you mean to return one column (which column to return?) from your table based on a condition against the 3rd column MultilistType?
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
I only need it to return only if there is key words (Compression , Tubigrip ) in the third column otherwise nothing .
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
This is a query for nurses to use to know if a patient has compression bandages ( three separate types of these and Tubigrip) . As you can see from image the top 4 returns have patient with these keywords but all others do not .
Query-Multilist.PNG
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
hers is a better screen snip
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
but yes Ryan Chong some like that . It has to be only a one click from query list
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
Thanks Ryan that worked perfectly That's heaps I owe you a beer or bournbon
0
 
Ryan ChongCommented:
As you can see from image the top 4 returns have patient with these keywords but all others do not .
ok, so what's your expected output?
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
here is the screen shot of the query after adding the  key word like Ryan said
MultiList-compresion-2.PNG
0
 
Pawan KumarDatabase ExpertCommented:
So do you need any more changes in that or not ?
0
 
Ryan ChongCommented:
here is the screen shot of the query after adding the  key word like Ryan said
ok coool, so is that solved your issue or you need further assistance?
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
not with this problem thanks heaps
0
 
Kirk saintSoftware Designer(Trainee)Author Commented:
Thanks again for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.