Home  |  Linux  | Mysql  | PHP  | XML
From:Shawn McKenzie Date:Thu May  8 13:13:20 2008
Subject:Re: Newbie - is there a function similar to the sql 'like' comparisonoperator?
revDAVE wrote:
> Newbie - is there a function similar to the sql 'like' comparison operator?
> 
> I would like to be able to compare 2 strings:
> 
> If $this ---*like or similar to*--- $that
> 
> That type of thing...
> 
> 
> I know of this page:
> 
> http://us3.php.net/manual/sl/language.operators.comparison.php
> 
> 
> But I don't see something 'like' or 'similar' to something else
> 
> 
> --
> Thanks - RevDave
> Cool @ hosting4days . com
> [db-lists]
> 
> 
> 
Probably the most similar that allows some wildcards (pattern matching) 
is ereg().  You have more power in that you can control what must match 
and how much.

In MySQL  'a' = ' a ' is true but 'a' LIKE ' a ' is false.  So you need 
to use the wildcard % to match anything  ' xxaxx ' LIKE '%a%' is true or 
_ to match one character ' a ' LIKE '_a_' is true.

The problem with similar_text() is that it gives you a percentage of 
similarity which may be misleading unless you also figure in the return 
of how many chars match.  For example similar_text('CAT', 'CA', &$p) $p 
would be 66.6%, is that like or not?

-Shawn
Navigate in group php.general at sever news.php.net
Previous Next




  
© No Copyright
You are free to use Anything
Site Maintained by PHP Developer
Powered By PHP Consultants