From: Phibee Network Operation Center (nocphibee.net)
Date: Tue Nov 03 2009 - 11:17:52 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]