Replace in MySql

[Anon]

Hi,
how can i replace a string using regular expressions directly in the query?

Ex: if i search "wrld" i want to find "hello world!" (deleting each vocal)
or
if i search "hxllx" i want to find "hello world!" (replacing vocals with "x")

LAMASE

[Anon]

In your query, use REGEXP instead of LIKE.

I'm assuming that you can write the UPDATE query and create your regular expression.

Look up REGEXP in the mysql manual for more details.

[Anon]

I don't want to UPDATE the table.... i just want to make a good SELECT: can you make me an example?

LAMASE

[Anon]

Then write your select statement and use REGEXP instead of LIKE.

Read the manual (examples provided). The manual is actually helful.
http://www.mysql.com/doc/P/a/Pattern_matching.html