Wild cards do work, but you have to make sure you use the right type. SQL uses % and I believe _ as wild cards. I know if you wish to use them in SELECT statements it would look like: SELECT * FROM pet WHERE name LIKE "b%" this would return anything from pet where the name starts with ab. Go look at: http://www.mysql.com/doc/P/a/Pattern_matching.html for more on this. However I dont know how you would do the same for updating tables. I tried using the % andsimilar for update but failed to get it to work. -nick
> Hello everyone > I want to alter 50 tables, and for each the names start with the string > 'mak' > Is there an SQL query, so that I can do the change in one command. I > have tried using wildcards - they don't seem to work in SQL. > Thanks in advance. > Aman > > _________________________________________________________________ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql- [EMAIL PROTECTED]> To > unsubscribe, e-mail > <mysql-unsubscribe- [EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php