LIKE '%,8,%' ? Probably not as elegant as you were looking for, but it works :)
Colin On Monday 06 July 2009 21:31:51 Highviews wrote: > Hi, > I have numbers separated with commas saved into a TEXT Field, for example: > > ROW1: 10,5,2,8, > ROW2: 2,7,9,65 > ROW3: 99,100,55,10,88, > etc... > > > Now i want to make a query like this: > SELECT * FROM table where numbers LIKE '%8%'; > > The above query when executed returned the following: > ROW1: 10,5,2,8, > ROW3: 99,100,55,10,88, > > Where it should only return ROW1: > ROW1: 10,5,2,8, > > But it is also detecting '88' from ROW2. > > Any solution to this? > I only want exact numbers to be searched out. > > > Thanks! > > > > --- > http://www.visualbooks.com.pk/ -- Your love life will be... interesting. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
