Re: [PHP] but mysql? (was: postgres and php)

2001-07-15 Thread teo

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.
 
 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] but mysql? (was: postgres and php)

2001-07-15 Thread Nuno Silva

hello,

[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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]