MySQL Forums
Forum List  »  InnoDB

Please help me in little SQL select syntax
Posted by: Tabish Siddiqui
Date: April 28, 2005 08:02AM

hello all,

I have countries name stored in database along with comma and other characters like ( ) ] }.... and when i am perfrming a search i am sending country name without any special charecter added.. for example..

"Micronesia, Federated States of" is a country name and when i am searching i am passing this name as "Micronesia Federated States of" without any comma..

Now i was using like statement but it is not matching and giving any result..

i was wrting syntax like

Select * from country where country_name like '%$country_name%'

Please help me..

Regards



Edited 1 time(s). Last edit at 04/28/2005 08:05AM by Tabish Siddiqui.

Options: ReplyQuote


Subject
Views
Written By
Posted
Please help me in little SQL select syntax
3122
April 28, 2005 08:02AM


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.