PDA

View Full Version : Where ******* Contains "******"?


N!ck
04-01-2002, 11:02 PM
is there a "CONTAINS" clause for MySQL or something similar?

FWC
04-02-2002, 04:06 AM
You can use LIKE with % wildcards. LIKE '%in%' would find any word containing 'in'.

Admin
04-02-2002, 04:39 AM
SELECT * FROM tblName WHERE (INSTR(haystack,'needle')>0

FWC
04-02-2002, 05:07 AM
Originally posted by FireFly
SELECT * FROM tblName WHERE (INSTR(haystack,'needle')>0 Well that's certainly better than what I suggested. :)