This is kinda it!
$this->db->or_like(array('sender' => $k, 'msg' => $k));As seen on http://stackoverflow.com/questions/23254305/multiple-like-clause-codeigniter
Tag Archives: sql
How to run a raw SQL in Laravel 4?
This is how.
DB::select(DB::raw('SELECT * FROM DIGITALWHORES'));
WordPress – find and replace
I got some wordpress blogs (20+) running on some servers, and from time to time, i need to make some FIND&REPLACE on my posts…
This is the simple way! Directly on mysql.
UPDATE wp_posts SET post_content = REPLACE ( post_content, 'Item to replace here', 'Replacement text here');
Please note the for security reasons the prefix wp_ is diferent… if you play by the rules you will need to see witch is is… wp-config.php has it.
mysql> UPDATE wpspt_posts SET post_content = REPLACE ( -> post_content, -> 'static.mycdn.com/banners/', -> 'static.mycdn.com/bnnrs/'); Query OK, 1477 rows affected (0.42 sec) Rows matched: 10795 Changed: 1477 Warnings: 0
This is a small hack to ABP – Ad Blocker Plus…
Horray!