Display rows in SQL table that contain a string

Posted on 2013-02-02
Medium Priority
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

Question by:Dovberman
LVL 71

Accepted Solution

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

Author Closing Comment

ID: 38846697


Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
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 …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

623 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