Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Display rows in SQL table that contain a string

Posted on 2013-02-02
2
Medium Priority
?
296 Views
Last Modified: 2013-02-02
I need to list rows in the Keywords table where the Keyword column contains the string 'penny'

What is the tsql syntax?

KewWordID    Keyword
528            2011 penny stocks
658            2012 best penny stocks
216            2012 best stocks
905            2012 cheap stocks
767            2012 penny stocks
1185            2012 penny stocks to buy

Thanks
0
Comment
Question by:Dovberman
2 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 1200 total points
ID: 38846660
select * from Keywords where keyword like '%penny%'
0
 

Author Closing Comment

by:Dovberman
ID: 38846697
Perfect.

Thanks
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question