MySQL remove specific number from list -

-

I have a database that has the following structure: 

 + ---- + - --- + ------------------- + --------------- + | ID | By | Name | List | + ---- + ---- + ------------------- + --------------- + | 1 | 1 | First name 12,6,5,3,2,66 + ---- + ---- + ------------------- + --------------- + | 2 | 1 | Second name 6,3,5 | + ---- + ---- + ------------------- + --------------- +  
 All I have to do is remove a certain number from the  list  column, for example, there can be thousands of rows in the "6" number ( table ) I need to remove in a special list id). 
 
 I have tried the following query that almost works, it can remove the '6' entry, but it can close 66 and leave empty list element (example:, 3) , 2): 
  
 Unfortunately I will not be able to use any external libraries for MySQL (like preg_replace) nor can I restructure the database, is there any way to do this?

If you can not be reconstituted with this hatred and need to be urgent, then I will seriously send you this job I do not recommend taking.

She

  • Finally 6
  • In the middle 6
    • said, you need to discriminate 3 cases:

    < Ul>
  • 6 In the beginning,

    • then you will need three questions 

      UPDATE `table` set 'list` = right (` list `, CHAR_LENGTH (` list`) -2) where the list 'like' 6,% '; Set the table `table 'SET` list` = LEFT (` list`, CHAR_LENGTH (`list`) -2)' LIST 'like'%, 6 '; Set 'table' 'table' SET` list` = REPLACE (`list`, ', 6,', '') where '%, 6,%' like 'list';   
     Continuous  2  Note - This is valid only for single digits. To make this universal use,  CHAR_LENGTH ("6") + 1 < / Code>

    Comments

    Post a Comment

    Popular posts from this blog

    import - Python ImportError: No module named wmi -

    -
    I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, & lt; Modu...
    Read more

    Editing Python Class in Shell and SQLAlchemy -

    -
    I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla...
    Read more

    lua - HowTo create a fuel bar -

    -
    I would like to create a fuel bar (empty with full tank). When the user touches the screen, the fuel once Dairejh these is my code: lifeBar = display.newImage ( "fuel_bar1.png") lifeBar.anchorX = 0 lifeboats. ======================== Lifetime Y = 37 screens Group: The Insert function (called Laifbar) However, I fuel Kansmoshn (equivalent to "pressed" variable to reduce the fuel tank "true") Have used. When pressed == is true, it means that the user is touching the screen: processed (fuel) processed () if life & gt; 0 and pressed == true remains = life - life 1 Life = life =. Wide-1 remains Value.text = string.format ("% d", life) End of this This function is active as the entrance event: runtime: addEventListener ( "Antrfrem" fuel Snsadna) it is very well, but my question is: pressed variable each time 5 seconds (once = = True) How is it possible to reduce the vitality width? I tried to add it to my touch even...
    Read more