SQL string search question?

Question

Is it possible to scan a tables field value for individual strings?

for instance... if this was listed ..

ID / Keyword / Description
1 / Hello / +1+2+3+4+5+6

could i search the description value for +5 and return true?

also, added on to that, is it possible to add a +7 to the end of that value without erasing the data easily?

thanks

Answer 1

Here is first query:



SELECT * from MyTableName

WHERE desctiption

LIKE '%+5%'





about the second part I am not sure right now.

Answer 2

For the 2nd part of your question



UPDATE yourTable

Set Description = Description + '+7'

WHERE ID=1

Answer 3

>is it possible to add a +7 to the end of that value



Update table_name

set Description=Description + '+7'

where id=1



By the way, you should reconsider the design.

Answer 4

Have u try full-text search feature ?

Answer 5

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Answer 6

http://blogs.technet.com/reeds/archive/2007/01/12/full-text-search-using-a-column-that-contains-a-list-of-keywords.aspx

http://www.kodyaz.com/articles/SQL-Server-Full-Text-Search-Indexing.aspx

http://www.sitepoint.com/blogs/2006/12/06/sql-server-full-text-search-protips-part-2-contains-vs-freetext/

http://www.sitepoint.com/blogs/2006/12/30/sql-server-full-text-search-protips-part-3-getting-ranked/