title: Using slash in MySQL database
body: <p>I am using mysql with php Yii framework.When doing data modelling I came accross some doubt.I have a table for user details like this.</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `tbl_users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `firstname` varchar(80) NOT NULL DEFAULT '',
    `lastname` varchar(80) NOT NULL DEFAULT '',
    `gender` varchar(6) NOT NULL DEFAULT '',
    `email` varchar(45) NOT NULL DEFAULT '',
    `company_name` varchar(80) NOT NULL DEFAULT '',
    `contact_no` varchar(45) NOT NULL DEFAULT '',
    `address` varchar(120) NOT NULL DEFAULT '',
    `state` varchar(45) NOT NULL DEFAULT '',
    `country` varchar(45) NOT NULL DEFAULT '',
    `created_by` int(11) DEFAULT NULL,
    `updated_by` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;
  </code></pre>
  
  <p>Here my problem is I want the state,country should be like this so that I can use the fields like <code>state/city</code></p>
  
  <pre><code> `state/city` varchar(45) NOT NULL DEFAULT '',
    `state/province` varchar(45) NOT NULL DEFAULT '',
  </code></pre>
  
  <p>So is it safe to use like this or I have to use only one option there?Any help and suggestions will be highly appriciable.</p>