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? Link to comment https://forums.phpfreaks.com/topic/115949-searching-a-query/ Share on other sites More sharing options...
trq Posted July 22, 2008 Share Posted July 22, 2008 Pardon? Link to comment https://forums.phpfreaks.com/topic/115949-searching-a-query/#findComment-596143 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.. Link to comment https://forums.phpfreaks.com/topic/115949-searching-a-query/#findComment-596292 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]' ??? Link to comment https://forums.phpfreaks.com/topic/115949-searching-a-query/#findComment-596298 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? Link to comment https://forums.phpfreaks.com/topic/115949-searching-a-query/#findComment-596874 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.