simple query

[Pag]

	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]