Using $wpdb->update with LIMIT 1

  • I am trying to get the next available value in a table and add user details against it. I would like to do something like

    UPDATE mytable
    SET email= ’email’
    WHERE email=”
    LIMIT 1

    and then

    SELECT value FROM mytable WHERE email= ’email’

    Would appreciate some pointers as I can’t seem to get LIMIT 1 working in update and it just updates all the empty rows.

    Thanks

  • The topic ‘Using $wpdb->update with LIMIT 1’ is closed to new replies.

Tags