Hi i request a small help for know if it's possible.
Anyone know if they have a Sql request for search the best value at one information: Sample: i have a table with: ID int 5 Chaine int 16 and this entry: 1 12345 2 123 3 12 i am search a request in "WHERE" : Chaine LIKE '123456789' and if he don't have into the database, he test Chaine LIKE '12345678' etc .. and when he arrive at 12345, he sent the ID information thanks for your help (PS: i use Perl for extract data) Jerome Sorry for my english -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org