firebird Query "starting with" is not working in MySQL

[Johan Harmse]

Hi
I used firebird and create queries to search for parts of a field or more that 1 field like this

SELECT * FROM table1 WHERE Name STARTING WITH 'Joh'

then it will display all the records that starts with 'Joh'

Or SELECT * FORM table1 WHERE addres1 CONTAINING 'Ave' OR address2 CONTAINING 'Avr' OR address3 CONTAINING 'Ave'

Then it will display all records that has die word 'Ave' in any of the 3 fields, its nice tot search for an address but it does work in MySQL what is the options to do something like that

Please help

Regards
Kite