[SOLVED] I want to search a mysql table for a particular strig, how to make the query ?

[jd2007]

for e.g. in a column 'text' , there are many words on row 1, i want to find for one word in that field how ?

below is a clearer example:

 

-----------------

text                         

-----------------

hello world !

-----------------

 

text is column name, its first row has the value "hello world", i want search the world "hello", what query to make ?...pls help...

[jd2007]

sorry for making two same post, i accidentally clicked post twice...sorry ...

[MadTechie]

SELECT * FROM table WHERE field LIKE '%Hello%'

 

% = * (wildcard)

 

is that what your looking for ?

[jd2007]

yes...thanks

 

[MadTechie]

~cougths~

 

Topic solved ?