TalkPHP - View Single Post

Sand_Devil · 04-05-2008, 04:25 AM

If I understand what you are suggesting... word being the entered string and blah_field being the database entry. || allows you to concatenate strings. To search for the % you need to place an escape, usually \

where word like ('%'||blah_field)

Should do the trick.

04-05-2008, 04:25 AM	#6 (permalink)
Sand_Devil The Wanderer Join Date: Nov 2007 Location: El Paso, TX Posts: 7 Thanks: 1	If I understand what you are suggesting... word being the entered string and blah_field being the database entry. \|\| allows you to concatenate strings. To search for the % you need to place an escape, usually \ where word like ('%'\|\|blah_field) Should do the trick. __________________ Because Every Child Deserves a Chance to Play Baseball in El Paso Last edited by Sand_Devil : 04-05-2008 at 04:28 AM. Reason: Additional clarification