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? Quote 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. Quote 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 Quote 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]") Quote 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.. :/ Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.