simple sql question

[iffoiffy]

Hi,

Suppose I have a field(A) in my table(Tab) which has a sentences like

"I work for a major company"


Now in my select statment I want to pick only those records where field "A" has word "major" in it..

How do i do that?

I thought there was some 'Any' operator ...


select * from Tab where A ?????????

 

[aardvark92]

Try:

SELECT * FROM Tab WHERE A LIKE "%major%"

The % wildcard represents a string of 0 or more characters.

 

[iffoiffy]

thanks I will try that, but don't you think if i use
% on both ends then it will pick a record which may not have the exact word.

suppose I do it %GST%

it will pick the record that might have 'MGSTM'

 

[r937]

use REGEXP to ensure that only the word major is found, but not the word majors

... where A regexp '[[:<:]]major[[:>:]]'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[iffoiffy]

thanks to everybody it works now