From: Rajeev Prasad
Date: August 11 2012 4:05pm
Subject: search any matching word in given string in table column which has only one word
List-Archive: http://lists.mysql.com/mysql/227984
Message-Id: <1344701102.27858.YahooMailNeo@web161704.mail.bf1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="-816086408-857956034-1344701102=:27858"

---816086408-857956034-1344701102=:27858
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

here is given string of type:...=A0=A0 "as23,rt54,yh79"=0Aand i have to loo=
kup in a table which has column "id" which has only one four letter word. i=
 have to select that row in which the colum 'id' value matches any of the w=
ord in given string... =0A=0Atable column: id=0Acontents like:=0A| id|=0A--=
--=0A|sd32|=0A|wa32|=0A|rt54|=0A=0Aafter that match row with id=3D'rt54' sh=
ould be returned.=0A=0Ai am not able to figure the sql statement for this? =
eventually i want to have DBIx statement to use in my perl code. So either =
suggestion will work for me.=0A=0Aty.=0ARajeev=0A
---816086408-857956034-1344701102=:27858--