MySQL Forums
Forum List  »  MyISAM

select query help
Posted by: vibra narayanan
Date: September 03, 2005 01:29AM

hai

i am a php developer. i ma stand in following area. anyone please help me


i need to search a key word from two fields from my tables

i am using following query


select * from ez_product where prodname like '%dsfsdf%' || skuno like '%dsfsdf%'


Result

it shows nothing

if i give "lether shooo" as a key the i get the result as "lether shooo".


expited result

if i give "lether" in text box the result will

1. lether shooo
2. jurkin in lether
3. lether boot
4. lether , etc... (match in found for lether)

please any one advice me.help me


i am using mysql 3.23.52-nt
PHP4.3/windows/IIS

Options: ReplyQuote


Subject
Views
Written By
Posted
select query help
3259
September 03, 2005 01:29AM
1789
September 05, 2005 03:33AM
1895
September 05, 2005 03:45AM


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.