To replace particular string with another in mysql use the following command update tablename set field = replace(field,’search_for_this’,’replace_with_this’);
Archive for the ‘MySQL’ Category
Replace particular string with another in mysql
Posted in MySQL on July 24, 2007 | Leave a Comment »
Regular Expressions
Posted in MySQL on July 23, 2007 | Leave a Comment »
A regular expression is a powerful way of specifying a pattern for a complex search. MySQL allows the following regular expression metacharacters: . — match any character ? — match zero or one * — match zero or more + — match one or more {n} — match n times {m,n} — match m through [...]
Full text search
Posted in MySQL on July 21, 2007 | Leave a Comment »
I was doing a research on implementing search using mySQL for my site. I learnt the following things. I would like to share it with you. One of the more useful MySQL features is the ability to search for text using a FULLTEXT index. Currently this is only available if you use the MyISAM table [...]
host is not allowed to connect to this MySQL Server
Posted in MySQL on July 20, 2007 | Leave a Comment »
To Solve this error, you have to update the mysql.user table. GRANT ALL PRIVILEGES ON [dbname].* to ‘[user]‘@’[hostname]‘ identified by ‘[password]‘ Check whether it updated the privileges. mysql> select Host, User, Password from user;