Re: [PHP-DB] Comparing Strings

2002-03-25 Thread Henrique Flach Latorre Moreno 

You could use the eregi() using regular expression,
it's probably the best way

see how 2 use in the http://www.php.net
At 11:59 25/03/02 +0100, you wrote:
Whats the best way to compare 2 strings (city names - one in db one user
entry)
At the moment I'm thinking to do the following ;

strip spaces
convert to lower
and then compare !

Has anyone got any better/other suggestions ??

regards
John



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Henrique Flach Latorre Moreno
Smart Tech Consulting
www.smartech.com.br
Av. Rio Branco 181, 1005
Centro - Rio de Janeiro - RJ
Tels : (21) 2532-6335


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Comparing Strings

2002-03-25 Thread Andrey Hristov 

If using mysql then the string comparison of fields is case insensitive except if the 
(var)char column is BINARY.
AFAIK mysql has support for RegEx-es. If you decide to use PHP, then use 
preg_match/replace but with 'i' modifier. This will make
the search case-insensitivi and will be faster than eregi().



Regards,
Andrey Hristov
- Original Message -
From: John Fishworld [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 25, 2002 12:59 PM
Subject: [PHP-DB] Comparing Strings


 Whats the best way to compare 2 strings (city names - one in db one user
 entry)
 At the moment I'm thinking to do the following ;

 strip spaces
 convert to lower
 and then compare !

 Has anyone got any better/other suggestions ??

 regards
 John



 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php