If Field Contains 1

[coldfused]

How would I do a Select statement looking for a specific word or group of words in a long text field?

Select *
From centers
Where c_specs "Contains" 'The Words I'm Looking for'

How do I run that SQL command on a long text?

Thanks in advance,
Carl

----------------------------------------
Online Marketing - de·ci·phered
Always Learning...

 

[johnwm]

You need the LIKE keyword:

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[coldfused]

I tried that originally and it didnt work. Turns out the word I was searching for was not spelt correctly.

Thanks.

----------------------------------------
Online Marketing - de·ci·phered
Always Learning...

 

[Kozusnik]

I found something odd yesterday in one of my scripts. It's a php script running something like...
SELECT * FROM table WHERE UCASE(field) LIKE '%BCER1P%'

Somewhere in the conversion, the %BC became 1/4 (not one slash four, but one quarter). I found that odd. I ended up removing the percents and changing the UCASE(field) to TRIM(UCASE(field)).

Mark

 

[hautnueil]

Hi coldfused,

I found your question from 7/2005 where you were looking for advice about migrating from Access to SQL.

http://www.tek-tips.com/viewthread.cfm?qid=1097761&page=2

I'm trying to do the same thing now and could use your help. I've having a *itch of a time finding info.

Any help, such as pointing me in the right direction would be much appreciated.