Need special MySql query Please

Discussion in 'Programming' started by DnHype, Jul 4, 2008.

0
  1. #1
    Hi there i need to filter my database to delete all entry from a table that contain special letter.

    Like ; " * > < ! ? : ( ) ~

    how to ?

    DELETE * FROM My_Table WHERE My_Row LIKE ?
     
    DnHype, Jul 4, 2008 IP
  2. Vooler

    Vooler Well-Known Member

    Messages:
    1,146
    Likes Received:
    64
    Best Answers:
    4
    Trophy Points:
    150
    #2
    I do not know regex and not even sure if mysql supports regex, here is your plain query which will do the job


    I hope it hlps.

    regards
     
    Vooler, Jul 4, 2008 IP
    DnHype likes this.
  3. DnHype

    DnHype Active Member

    Messages:
    1,010
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    80
    #3
    Work !!
    So cool thank thank !
     
    DnHype, Jul 4, 2008 IP