Checking whether a field in a table contains a specified string

Hunky · #1 (**permalink**) 08-07-09, 07:43

Hello Everyone,

I have a table with 2 fields...
say
TextID and TextValue.

------- -------------------------------
TextID TextValue
------- -------------------------------
101 hello every one
108 hey hello dear
121 please say hello
143 home sweet home

What i want is a query that will select all the TextID's from the table where
TextValue field contains the word "hello".

Any help is deeply appreciated.

thanks in advance...

r937 · #2 (**permalink**) 08-07-09, 08:03

Quote:

Originally Posted by Hunky

Any help is deeply appreciated.

this is really basic SQL

maybe you should take a tutorial

Code:

SELECT TextID
  FROM daTable
 WHERE TextValue LIKE '%hello%'

Internet Services

Web Development

Digital Marketing

Consumer Tech