• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Query with like and or_like not returning like results

#4
[eluser]CrustyDOD[/eluser]
Use % before/after the search term.

For example:
Code:
SELECT ... LIKE 'Sara%'

If you have huge DB i would recommend full-text searches as LIKE is really slow..


Messages In This Thread
Query with like and or_like not returning like results - by El Forum - 10-19-2008, 02:59 PM
Query with like and or_like not returning like results - by El Forum - 10-19-2008, 03:10 PM
Query with like and or_like not returning like results - by El Forum - 10-19-2008, 03:42 PM
Query with like and or_like not returning like results - by El Forum - 10-19-2008, 03:47 PM
Query with like and or_like not returning like results - by El Forum - 10-19-2008, 05:12 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.