Try "SELECT * FROM `phrases` WHERE ph like "%who%"; The percent symbol is the wildcard character for mysql queries
HTH > -----Original Message----- > From: Pag [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 11:08 AM > To: [EMAIL PROTECTED] > Subject: simple query > > > > > Imagine i have a table "phrases" with a field "ph" with > contents like these: > > - who was it > - who wasnt it > - no i didnt > - yes i was > - dont know who > > I want to make a SELECT that gives me only the entries that > have the word > "who": > > Something like > > SELECT * FROM `phrases` WHERE ph="who*"; > > I tried the manual but cant make sense of it. How can we > use wildcards on > selects? > > Thanks > > Pag > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]