Search a string in a column

Question

0.00/5 (No votes)

See more:

Hello,
I have a search page in my project. User tries to search on product details like
1) Name
2) Description

Here some times description my be a an anchor tag and syntac of the anchor tag is saved in Description column.

For example : Description may contain like this

<html href="/uStore/3/Category/7/Product/69/" >Mobile Phone.</html>

the description column will contain total tag syntax.

so i have placed to search like this Description like '%@Searchword%'

when User tries to search with key word "Mobile", the record is being listed out in my search
But my problem now is that when user search on word "Category" . This record is also coming out... as its anchor tag contains its syntax..
now i want a query to search a word that is present b/w >... <
i.e Only when search on Mobile Phone should be listed out

Thanks in advance... And correct anwer is highly appreciated :)

Posted 16-Jul-14 20:19pm

jing567

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ashok rathod · Answer 1 · 2014-07-16T20:26:00

Solution 1

XML

IF Contains(Description,"<html>")
BEGIN  Description Like "<html>%@Searchword%</html>"
END
ELSE  Description Like "%@Searchword%"

Posted 16-Jul-14 20:26pm

ashok rathod

Updated 16-Jul-14 20:40pm

v3

Comments

jing567 17-Jul-14 2:27am

Some times Description column may remain normal text also.... at that consition what to do?

jing567 17-Jul-14 2:30am

Just now i tried by searching like this '>%Mobile%'

But it did not worked.... :(

ashok rathod 17-Jul-14 2:37am

please see updated solution

jing567 17-Jul-14 2:39am

It worked by little change

Description like '%>%' +'%Mobile%'

ashok rathod 17-Jul-14 2:41am

please see condtional statement which will serve your both purpose

jing567 17-Jul-14 2:56am

Thanks ashok.... i will check it and let you know... i am new to sql... can u give better syntax to place in where condtion of my query.... I am using Sql2008...Please

jing567 17-Jul-14 3:44am

I have corrected my synatax and done... but ur logic failed bro.... because when else condition executes both the records will be listed out again :(
Again the problem continues :(