View Single Post
  #2 (permalink)  
Old 12-02-08, 06:53 AM
End User's Avatar
End User End User is offline
Level II Curmudgeon
 
Join Date: Dec 2004
Posts: 3,027
Thanks: 14
Thanked 35 Times in 33 Posts
Quote:
Originally Posted by richardhotscript View Post
instead of returning only 110 and 52 it return these IDs 110,52 and 1 when it should ony be 110 and 52. Can you guys help fix this? Is there I can fix this without modifying the structure of my table?
If you use "LIKE" then mySQL returns all of the values that match any part of your specified string, which is probably why you're getting values back that you don't want or expect.
__________________
I don't live on the edge, but sometimes I go there to visit.
-------------------------------------------------------------------------
Sanitize Your Data | Oracle Date & Substring Functions | Code Snippet Library | [url=http://www.codmb.com/Call Of Duty[/url]
Reply With Quote