suck4it Posted February 11, 2010 Share Posted February 11, 2010 Hello so I need to replace some text in all table for that I use REPLACE function and it works great but the problem is that it's only affects 10 queries but I need about ~20 000. So maybe there's limiter or smth? Everything is on xampp and I'm using phpmyadmin for that.. Any suggestions? Link to comment https://forums.phpfreaks.com/topic/191775-sql-query-affect-only-10-queries/ Share on other sites More sharing options...
aebstract Posted February 11, 2010 Share Posted February 11, 2010 Can you show the query you are running and what you are trying to update? Can't really suggest any solutions without seeing what you're actually doing here. Link to comment https://forums.phpfreaks.com/topic/191775-sql-query-affect-only-10-queries/#findComment-1010790 Share on other sites More sharing options...
sader Posted February 11, 2010 Share Posted February 11, 2010 make sure that u dont have LIMIT 10 in your replace query Link to comment https://forums.phpfreaks.com/topic/191775-sql-query-affect-only-10-queries/#findComment-1010794 Share on other sites More sharing options...
suck4it Posted February 11, 2010 Author Share Posted February 11, 2010 Query looks like that UPDATE users SET status = replace(status,"b]","u]") Link to comment https://forums.phpfreaks.com/topic/191775-sql-query-affect-only-10-queries/#findComment-1010801 Share on other sites More sharing options...
suck4it Posted February 11, 2010 Author Share Posted February 11, 2010 btw I found input named "Delimiter" it's value ";" I tried put "100" and etc. but it just don't listen.. :/ Link to comment https://forums.phpfreaks.com/topic/191775-sql-query-affect-only-10-queries/#findComment-1010898 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.