MySQL Forums
Forum List  »  Firebird

firebird Query "starting with" is not working in MySQL
Posted by: Johan Harmse
Date: May 23, 2007 03:44AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
firebird Query "starting with" is not working in MySQL
10977
May 23, 2007 03:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.