Search Query..?

[Wong CS]

Dear developers,

i would like to giv my scenario here:

my DB wif a field, called Title varchar(40) where user can put their item
wif title, for example, "40GB harddisk for sale" and other item..

for another user who wish to buy harddisk wil search for his desired item
but typing "harddisk".. all other columns which match the "harddisk" wil
returned..

may i know wat class to do those function..?? isn't Regex.? if there is any
sample code or site to intro, then it will b a better solution...

pls advice and thanks in advance..


cheers,
Wong CS

 

[gaidar]

As I understood your question - it's just a simple SQL query: SELECT * FROM
Your_Table WHERE Title LIKE '%harddisk%'

 

[Jeff Louie]

The safest way is to use a parameterized query. If you construct your
own sql
on the fly you need to protect against SQL injection. At a minimum,
replace
embedded singe quotes with two single quotes.

http://www.geocities.com/jeff_louie/net_filtering.htm
http://www.geocities.com/jeff_louie/parameterized_queries.htm

Regards,
Jeff
for another user who wish to buy harddisk wil search for his desired
item
but typing "harddisk".. all other columns which match the "harddisk" wil
returned..