>If the string is theString + space and another row has an entry with >theString (+ no space), the query returns BOTH rows. > >Is there a way to get around returning the latter entry?
You could do something like: select stuff from mytable where stuff = 'foo ' and length(stuff) = 4; -- Steve Bacher Draper Laboratory Cambridge, MA, US -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
