var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have to select from table some data.
On one of columns i have list(key:1,2,3,4,...).
I need select by one of components from this list:
Select * from tbl ... but where key=2(to example) can't help me.
What can i use?
This table organization is a problem. It is called 0NF (or chaos, or zero normal form).
The best option is to fix the underlying problem, making a child table that contains one row for each of the possible values in your list. That is called 1NF, or first normal form.
Short of that fix, you have a real problem. You can resort to doing table scans using the LIKE keyword, but those should only be an absolute LAST resort!
That what i need.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors