hello, i hv created a table with 11 fields. two of them where i m getting problem are country name and the country code
all other fields work properly during selection except these two fileds are : (country varchar(30),code char(2)); when i retrieve records using follwg query : select * from table where country='United States' and code='US'; or select * from table where country='Iran' limit 2; or select * from table where country like 'Nepal' limit 3; it gives empty set; But if i give :s select * from table where country like 'United S%' and code='US'; it works select * from table where code='NP'; it works; why is it so bcoz of the Space between 2 words, the problem arises ? How to retrieve such fields then by giving specific value? can anybody help me ==================================================== N. Kavithashree =================================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
