select query help
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
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.