not able to insert/update mysql keywords in database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anjali321
    New Member
    • Jun 2010
    • 4

    not able to insert/update mysql keywords in database

    I am using codeigniter and i have something like '.....you may insert keywords into the title of a page where....' in the field. I am not able to save or update it because of the insert word in the field. the same thing happens when i use update n other keywords. it is not possible to skip those words as they are really important.
    Please help me to get out of it.
    Thanks
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Depending on what engine you're using, you can use a delineator. Try the ` or bracket [] characters to delineate a string as an object.
    Code:
    SELECT `select` FROM someTable

    Comment

    Working...