jd2007 Posted August 18, 2007 Share Posted August 18, 2007 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... Quote Link to comment Share on other sites More sharing options...
jd2007 Posted August 18, 2007 Author Share Posted August 18, 2007 sorry for making two same post, i accidentally clicked post twice...sorry ... Quote Link to comment Share on other sites More sharing options...
MadTechie Posted August 18, 2007 Share Posted August 18, 2007 SELECT * FROM table WHERE field LIKE '%Hello%' % = * (wildcard) is that what your looking for ? Quote Link to comment Share on other sites More sharing options...
jd2007 Posted August 18, 2007 Author Share Posted August 18, 2007 yes...thanks Quote Link to comment Share on other sites More sharing options...
MadTechie Posted August 18, 2007 Share Posted August 18, 2007 ~cougths~ Topic solved ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.