Increase for 1 using REPLACE function

I have to increase 'no_of_visits' for 1. Using UPDATE function is easy: update visits set no_of_visits=no_of_visits+1 where visitor_id=123 but, how it should be (if possible at all) if I want to use REPLACE function? I tried something similar replace into visitors values ($visitor_id

Re: Increase for 1 using REPLACE function

2011/03/18 17:24 -0500, Afan Pasalic I have to increase 'no_of_visits' for 1. Using UPDATE function is easy: update visits set no_of_visits=no_of_visits+1 where visitor_id=123 but, how it should be (if possible at all) if I want to use REPLACE function? I tried something similar replace

REPLACE function

I have field varchar(20) that stores phone numbers. Phone number can be in different format. So I need only digits from the field. How I can do such replacement? TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: REPLACE function

If I understand your problem, MySQL allows you to use regular expressions - so you could use the REGEXP function to remove the spaces. Check out the mysql site... Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: REPLACE function

Sent: Thursday, April 28, 2005 6:37 AM Subject: Re: REPLACE function If I understand your problem, MySQL allows you to use regular expressions - so you could use the REGEXP function to remove the spaces. Check out the mysql site... Chris -- MySQL General Mailing List For list archives: http

Question: REPLACE function

select REPLACE('www.mysql.com', 'w', 'Ww'); - 'WwWwWw.mysql.com' == Is there any way to make this REPLACE function match regular expressions rather than substrings? Lets say, if you wanted to remove all non-alhpabetic characters from a column, you could do: select REPLACE(Address