Re: but mysql? (was: postgres and php)

hello, teo@gecadsoftware.com 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