try this: WHERE concated_field LIKE '87682%' or WHERE concated_field LIKE '87682<next>_____'
it is based on SQL-99, not using PHP ----- Original Message ----- From: "Barry" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, May 09, 2006 8:49 PM Subject: Matching problem > Hello everyone! > > I have a slight problem matching rows. > > My problem is the Value in a textfield is: "87682<next>39857" > > I created that with concat. > Is there a way to match one specific number out of that field? > like WHERE SUPERFUNCTION(concated_field) = 87682 > > Is something like that possible in any way? > Or does something like that function exists? > Well in PHP you a function called in_array() which would work kind of > similiar what i want to do.
