Re: [PHP] but mysql? (was: postgres and php) From: Nuno Silva (nuno_silva <email protected>)
Date: 07/15/01

hello,

teo <email protected> wrote:

> Hi Nuno!
> On Sat, 14 Jul 2001, Nuno Silva wrote:
>
>
>>hi there!
>>
>>the operators you want are ~ and ~* and !~ and !~*.
>>select name from table where name ~* 'test';
>>
>
> any idea of something like this in MySQL? I was used to pg and I have no idea
> of something equivalent in My.
>

these operators do regexp matches in postgresql. to do this in mysql you
have the REGEXP operator:
http://www.mysql.com/doc/R/e/Regexp.html

Hope it helps,
Nuno Silva

>>to see all operators availlable type \do in psql's interactive mode ;)
>>
>>Regards,
>>Nuno Silva
>>
>>Derek wrote:
>>
>>
> -- teodor
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>