Next LUG meet: 12 Oct 2003 around 4 pm - VJTI Computer Centre -------------------------------------------------------------
hii this should work for u SELECT * FROM weather WHERE city LIKE 'new%' hope that was useful Nikhil ----- Original Message ----- From: "rahul revo" <[EMAIL PROTECTED]> To: "linux mail list" <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 3:28 PM Subject: [ILUG-BOM]sql query help > Next LUG meet: 12 Oct 2003 around 4 pm - VJTI Computer Centre > ------------------------------------------------------------- > hi everyone, > i need help on a sql query. > consider a table weather containing a column city. > suppose i have two rows with data in the city column as 'new delhi' and > the second as 'new whatever'. > so to select one row with say 'new delhi' i would give the following sql > command > SELECT * FROM weather WHERE city = 'new delhi'; > > what is the query if i want to select all rows with 'new' as a pat of > the string in the city column? in this case both the above rows should > be returned > > thanks > rahul. > > > > > -- > http://mm.ilug-bom.org.in/mailman/listinfo/linuxers > > > -- http://mm.ilug-bom.org.in/mailman/listinfo/linuxers
