Results 1 to 2 of 2
Nov 10, 2009, 17:09 #1
- Join Date
- Nov 2009
- 0 Post(s)
- 0 Thread(s)
Searching for Text Between Strings
I need help formatting a search query to exclude results found between two strings.
Specifically, I am trying to search a vBulletin database for text in posts while excluding text within quote tags. So I want don't want any results that are between "[quote" and "[/quote]".
Lets say I'm searching for "yellow". How would I format this to exclude all instances within the quote tags?
SELECT pagetext FROM post WHERE yellow