up
نمایش نسخه قابل چاپ
up
سلام یه کوئری هست این چمله تو گوگل سرچ کننقل قول:
نوشته اصلی توسط behnam_rs232
جانشینی کلمه در دیتابیس
و یا raplace word Database
بیا خودم سرچیدمو این زیر
MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string (from_string) to be replaced by new string (to_string). This is useful if there is need to search and replace a text string which affects many records or rows, such as change of company name, postcode, URL or spelling mistake.
The syntax of REPLACE is REPLACE(text_string, from_string, to_string)
MySQL reference describes REPLACE as function that returns the string text_string with all occurrences of the string from_string replaced by the string to_string, where matching is case-sensitive when searching for from_string. text_string can be retrieved from the a field in the database table too. Most SQL command can be REPLACE() function, especially SELECT and UPDATE manipulation statement.
For example:
update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);
update client_table set company_name = replace(company_name, ‘Old Company’, ‘New Company’)
The above statement will replace all instances of ‘Old Company’ to ‘New Company’ in the field of company_name of client_table table.
Another example:
SELECT REPLACE(‘www.mysql.com’, ‘w’, ‘Ww’);
Above statement will return ‘WwWwWw.mysql.com’ as result.
How to find and replace word in text from mysql database?"
And MySQL table words, with to 3 column id, word and replaceWord. I have more than 4000 words in databese.
Table:
id word replaceWord
1 text sentence
2 word letter
3 mysql MySQL
4 .. ...
5 .. ...
6 .. ...Result:
"How to find and replace letter in sentence from MySQL database?"
I know how to do this without database, but i need database.
<?php
$text="How to find and replace word in text from mysql database?";
$replaceWord=array( "text" => "sentence", "word" => "letter", "mysql" => "MySQL");
echo strtr($tekst, $replaceWord);
?>
آقا ممنون از همتون دست گل تک تک تون درد نکنه مشکل لود نشدن عکس ها رو پیدا کردم و رفع شد