Jump to content


Staff Alumni
  • Content count

  • Joined

  • Last visited

  • Days Won


fenway last won the day on November 8 2015

fenway had the most liked content!

Community Reputation

20 Good

About fenway

  • Rank
    MySQL Si-Fu / PHP Resident Alien
  • Birthday 07/08/1979

Profile Information

  • Gender
  • Location
    Toronto, ON
  1. You can do magic with SUBSTRING_INDEX and POSITION, but I'm not sure you want to.
  2. fenway

    how to search only letters and numbers in tables

    You can use REGEXP -- but it won't be very efficient.
  3. fenway

    duplicate entry with a series number

    Duplicate should be referring to individual field values, not parts of a field -- storing delimited data that you need to consider separately is likely going to bite you soon enough, if it hasn't already. There's all sorts of tomfoolery you can do with FIND_IN_SET(), but I don't recommend it.
  4. Just post the EXPLAIN and we'll see how bad it is.
  5. fenway

    php and mysql transaction issue

    Very difficult to tell what you're fererring to -- but I'm assuming that your PHP code isn't actually *making* a table -- DML vs DDL matters.
  6. fenway

    Back To Badged: Ch0cu3r

    Welcome back... it's been a while, but I'm still here ;-)
  7. fenway

    Pull columns from 2 tables

    Assuming it truly goes into the "same dropdown", you might get away with some version of UNION.
  8. fenway

    Username changes

    Great, so how I am supposed to abbreviate that? .j? CV was so much easier.
  9. fenway

    Web Host List

    I've heard nothing but horror stories about them.
  10. fenway

    PHPFreaks Tutorials Wishlist

    Well, a scalar subquery, that is.
  11. fenway

    [SOLVED] mysqldump and utf8 encoding

    Hmm... I wonder if that's related to this?
  12. fenway

    [SOLVED] mysqldump and utf8 encoding

    That's why it's not working -- redirection on the command-line will not deal with UTF8 properly; use the -r filename option instead.
  13. fenway

    [SOLVED] mysqldump and utf8 encoding

    Show exactly the command you're using.
  14. fenway

    [SOLVED] MySQL problem

    What does the error log say?
  15. fenway

    Windows GUI for MySQL

    PHPMyAdmin is just a cumbersome tool for any but very basic things... if you want to edit 7 records at the same time, that would require about 100 clicks in PHPMyAdmin. It's just a very kludgy interface.

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.