Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
knicker
Starting Member
1 Post |
 Posted - 2009-01-17 : 10:53:15
|
| Hello,I hope my question falls in the right forum. I have a content web 2.0 website with ms sql database. As most content websites, every file has Title, description and tags added by uploaders.I would like to know if there is any standard algorithm for SQL search based on title description and tags.Thank! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-17 : 11:23:33
|
nope. just use LIKE select *FROM tableWHERE title like '%' + yourvalue + '%'OR description like '%' + yourvalue + '%'OR tags like '%' + yourvalue + '%' |
 |
|
|
|
|
|
SQL search