Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' In case you have assoc array serialized you can use: SELECT ...
Developers Map
Discy Latest Questions
Hello Guys Here we are showing how to delete duplicate row from mysql database using join query DELETE t1 FROM ot_sub_district t1 INNER JOIN ot_sub_district t2 WHERE t1.sub_district_name = t2.sub_district_name;
Laravel is a most common framework. it is very easy to use and learn. when we get data from database we require to manage to take single database column for multiple integer ids.when we store comma seperated ids in database ...
How to use REPLACE() function Here we describe the replace method in MySQL MySQL REPLACE() replaces all the occurrences of a substring within a string.