whiteboikyle Posted July 22, 2008 Share Posted July 22, 2008 okay well i have a query that goes like "SELECT * FROM pages WHERE pages = 'news'" well in this `pages` there is a column called class it is a text based the row is pages : news class : [sep]test[sep][sep]test2[sep] now the user will have default [sep]test[sep] I would like to know how i can search [sep]test[sep] in the column class? Quote Link to comment Share on other sites More sharing options...
trq Posted July 22, 2008 Share Posted July 22, 2008 Pardon? Quote Link to comment Share on other sites More sharing options...
whiteboikyle Posted July 22, 2008 Author Share Posted July 22, 2008 if you have a query that results [sep]test[sep][sep][sep]test2[sep] how can you do a search inside that to search for [sep]test[sep] All the other forums get what i type except this 1.. lol i will post it on those ones.. Quote Link to comment Share on other sites More sharing options...
huesped214 Posted July 22, 2008 Share Posted July 22, 2008 SELECT * FROM pages WHERE class like '[sep]test[sep]' ??? Quote Link to comment Share on other sites More sharing options...
whiteboikyle Posted July 22, 2008 Author Share Posted July 22, 2008 the "like" makes it search with in it? 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.