Thread: Help with search syntax please.
View Single Post
Old 04-15-2011, 09:27 PM   #2
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by rwelbourn View Post
I need to know how to search for all books that have the same value in the author and title fields.
You can't. At least, not with a search. You can create a composite column that compares the author and title fields and produces 'yes' or 'no' as appropriate with the 'strcmp' function.
Starson17 is offline   Reply With Quote